I want to create a search system with PHP that searches multiple tables for the item the user is searching for. I dont know how to search multiple tables though.

I have 3 separate tables i want to search from, table_one, table_two, and table_three. In each of these tables there is a row called "Name".

I know how to search through 1 table but not 3 at a time.


So it would be like this for ONE table: "SELECT name FROM table_one WHERE name LIKE %$search_text%"

I would assume the MySQl should look something like:
"SELECT name FROM `table_one`,`table_two`,`table_three` WHERE name LIKE %$search_text%".

You could also look at the MySQL Manual:
http://dev.mysql.com/doc/refman/5.0/...xt-search.html