Sitewide Search - Requiring Multiple Tables

[1internet]

I want to be able to search my entire site over all the tables, e.g. restaurants, entertainment, hotels, etc.

How is this done?

Also what if I wanted to search through more than one clolumn, e.g. title and body, and then further, what if I wanted to rank the ones that contained the search query in the title, ahead of the ones in the body?

[NomadicJosh]

To get you started, your query could start as

 

mysql_query( "SHOW TABLES FROM name_of_database" );

 

or

mysql_query( "SELECT * FROM information_schema.`COLUMNS` C WHERE TABLE_SCHEMA = 'YOUR_DATABASE'" );

[fenway]

You want a proper fulltext index -- MySQL isn't really good at that -- check out Sphinx.