Database wide search

[OhLordy]

I want to write a query to search every table in my database (about 200 tables) to see if any one of them has any record of a particular product code is there any way of writing a quick easy query to do this

sort of like

SELECT * FROM (all tables) WHERE product_code='$value'

Many Thanks
Rob

[The_Chancer]

Something like:

$database_name='mysql_dbase_name';
$result=mysql_list_tables($database);
while(list($tables)=mysql_fetch_array($result))
{
     $query=mysql_query("SELECT * FROM $tables WHERE product_code='$value'");
     if (mysql_num_rows($query>1)) {
          $answer=mysql_fetch_array($query);
          echo "".$answer[product_code]." has been found in table ".$table."";
          }
}

Perhaps ?

[OhLordy]

Excellent, that's worked great.
Thank you very much