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?
Sitewide Search - Requiring Multiple Tables
Started by 1internet, Nov 26 2012 08:28 PM
2 replies to this topic
#2
parkerj
-
- Members
-
- 141 posts
Advanced Member
- LocationBoston, MA
Posted 26 November 2012 - 09:21 PM
To get you started, your query could start as
or
mysql_query( "SHOW TABLES FROM name_of_database" );
or
mysql_query( "SELECT * FROM information_schema.`COLUMNS` C WHERE TABLE_SCHEMA = 'YOUR_DATABASE'" );
#3
fenway
-
- Moderators
-
- 16,156 posts
MySQL Si-Fu / PHP Resident Alien
- LocationToronto, ON
Posted 30 November 2012 - 12:36 AM
You want a proper fulltext index -- MySQL isn't really good at that -- check out Sphinx.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
