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

 

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

 

[PFMaBiSmAd]

Why do you have a lot of tables that you would like to search at one time? That implies that your table design is not normalized and makes searching for same information across the tables directly impossible.

 

What are these tables are being used for?

 

Edit: Never mind, I just noticed your username. You were previously told that creating separate tables for each topic would not work out. You should not be surprised at this point that you cannot directly search through the different tables and find the information you want.