[RESOLVED] 'show tables where' query

[damienmcd]

I'm looking to show a list of tables where the content of one of the columns matches a search term. I have tried

SHOW TABLES WHERE comment LIKE '$searchterm%'

and get this error

Unknown column 'comment' in 'where clause'

.

I know this query is not correct but I am wondering is there a way to get the same results with a different query.

Thanx in advance

[chetan1]

Instead of using comment place condtion which you want. Therefore showing this kind of error.

---

website design

[NogDog]

The WHERE clause in a SHOW query can only be used for columns returned by that specific SHOW query. For SHOW TABLES, there is only one column, the "Tables_in_<db_name>" column (where "<db_name>" is the database name).

[damienmcd]

Thanks for your help guys. I got it working by using show tables and then using a loop that made the appropriate select statement for each of the tables that were returned.