[SOLVED] Check if a table exists in a database

[nathanblogs]

Hey,

 

I'm sure this has been answered a million times before but I couldn't find it after 30minutes of searching.

 

Is there a query that will allow me to check whether a table exists within a database?

[toplay]

# Returns details about a table. MySQL will return error 1146 when table does not exist.

describe put_table_name_here;

 

# Returns table names found in DB. You can then look through the rows to find if a particular table exists (or not).

show put_table_name_here;