Jump to content


Photo

performing full text search in mysql


  • Please log in to reply
1 reply to this topic

#1 darkcarnival

darkcarnival
  • Members
  • PipPipPip
  • Advanced Member
  • 162 posts

Posted 10 August 2006 - 12:25 AM

hey,

my data is getting bigger and so i want to add full-text to make searching better.

but one item i want to make 4 fields full-text searchable as they all play a huge role in finding the correct item.

i found a tutorial that gave me a small idea on it but it didnt get too informed on it.

if anyone can give me some more details on this, I'd like that :)

thanks :)

#2 fenway

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

Posted 12 August 2006 - 02:57 PM

There is a ton of information in the refman pages... basically, you simply create a 4-column FULLTEXT index, and off you go.
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