Re: Search Multiple Columns and Tables

[Andrew Germishuys]

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!!