mb81 Posted August 31, 2006 Share Posted August 31, 2006 Hey everyone, I'm getting more into using user search criteria to return a list from mysql and was wondering if anyone had some good search methodology when the user may be entering up to 4 words and I need to search in 4 or 5 different fields?I thought about using some complex joinings AND LIKE, etc, but I am thinking there has to be something better. Any thoughts? Link to comment https://forums.phpfreaks.com/topic/19267-search-methodology/ Share on other sites More sharing options...
fenway Posted August 31, 2006 Share Posted August 31, 2006 A FULLTEXT index can span multiple fields (in the same table only), and is a good first attempt, assuming you can enough records to support it. Link to comment https://forums.phpfreaks.com/topic/19267-search-methodology/#findComment-83568 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.