MySQL SHOW TABLES

ArizonaJohn

Hello,

In a MySQL database called "feather," I have a lot of tables, and each table has a column called "site."

I'm trying to show all tables that contain a record equal to $entry in the column "site."

How do I do that? I have some code below but I doubt it works.

Thanks in advance,

John

Expand|Select|Wrap|Line Numbers

 $data = mysql_query("SHOW TABLES FROM feather WHERE site CONTAINS '$entry'") 

or die(mysql_error());

code green

There may be a reason, but if you are trying to do something like this, then your database design has gone horribly wrong

r035198x

Yeah, please explain why you have realized that you need to do this.

P.S Yes your attempt is also wrong.

MySQL SHOW TABLES

re: MySQL SHOW TABLES

re: MySQL SHOW TABLES

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about