search every table & partial matches

[87dave87]

How can I search every table in my database?

&

How can I make it so the query looks for partial matches.

This is my results page: -

[code]
<?php

$database="mydatabase";
$emusearch = $_POST['emusearch'];
mysql_connect ("localhost", "user", "pass"); 
@mysql_select_db($database) or die( "Unable to select database");
$sql = mysql_query("select * from windows_atari2600 where emulator = '$emusearch'");
if(isset($sql)){
while ($get_info = mysql_fetch_row($sql)) { 
  echo "<tr>"; 
  foreach ($get_info as $field) echo "<td>$field</td>\n";
  echo "</tr>\n";
}
}else{
  echo "<tr>";
  echo "We cannot find your infomation.";
  echo "</tr>\n";
}
?>
[/code]

[ober]

SELECT * FROM tablexyz WHERE x LIKE '%partialword%'

And I'd suggest putting all your tables in an array and looping through this array running the query and echoing results but replacing the table name from the array each time.