title: Search Multiple Tables at in one query (MySQL/PHP#)
body: <p>I have about 15 tables, each table containing about 10, 000 rows and about 30 columns. I want the users of my site to be able to search for a Part Number, or a product/description and display the results. Regardless of which table it's in.</p>
  
  <p>Each product page is the same as the name of each corresponding table. So if a product is found, it will just display a link to the correct page (the filename is the name of the table).</p>
  
  <p>Can't we just do something like:</p>
  
  <p>query = "find $q in dbase.tables"; ?</p>
  
  <p>And if $q exists in a table, return the name of the table it was found in?</p>
  
  <p>Any help is appreciated!</p>
  
  <p>Thank you</p>