MySQL Forums
Forum List  »  Full-Text Search

Re: Search Multiple Columns and Tables
Posted by: Andrew Germishuys
Date: January 21, 2009 08:37AM

Do you have fulltext indexes on the relevant fields?

You can then use match('column names') against('search criteria' in boolean mode)
This way, you can use boolean to search, e.g. "+grade +five +history" which will then search for fields that contain all those words, and should give you the results you are looking for.
You can also then use "+grade +five +history -war" and it will find fields with the first three, but not the last keyword. Using like, you'll have to split your input, and search on each keyword separetly. Fulltext search on a bigger database will also be a lot faster, but only runs on MyISAM.

Hope that helps you get going!!

Options: ReplyQuote

Written By
December 11, 2008 01:52PM
Re: Search Multiple Columns and Tables
January 21, 2009 08:37AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.