Jump to content


Photo

Search methodology....


  • Please log in to reply
1 reply to this topic

#1 mb81

mb81
  • Members
  • PipPipPip
  • Advanced Member
  • 120 posts

Posted 31 August 2006 - 03:43 PM

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?

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 31 August 2006 - 04:22 PM

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