Jump to content


Photo

Search: FULLTEX or LIKE ?


  • Please log in to reply
2 replies to this topic

#1 mgm_03

mgm_03
  • Members
  • PipPipPip
  • Advanced Member
  • 49 posts
  • LocationFort Worth, TX

Posted 29 August 2003 - 06:07 PM

My table has a column for members to enter a text description up to a few hundred characters.

I want a visitor to search that column using keywords entered into an HTML form.

...just read a tutorial at www.onlamp.com about MySQL FULLTEXT searching...seems very powerful.

Question: Would you use that or just insert a LIKE clause in your query?

Thanks!
Guru?...in my dreams!
Sorry Everybody

----------------------

#2 McGruff

McGruff
  • Members
  • Pip
  • Newbie
  • 5 posts

Posted 03 September 2003 - 09:05 PM

It would depend on how much people were entering for their descriptions, and how many users you had. This is from the mysql website:

Such a technique works best with large collections (in fact, it was carefully tuned this way). For very small tables, word distribution does not reflect adequately their semantic value, and this model may sometimes produce bizarre results.


They don\'t seem to specify how large is \"large\", but I don\'t think a few hundred characters would be large, unless you have a large number of members.
McGruff [br] [br]\"I\'m working so I won\'t have to try so hard\" [br]- The Strokes

#3 mgm_03

mgm_03
  • Members
  • PipPipPip
  • Advanced Member
  • 49 posts
  • LocationFort Worth, TX

Posted 04 September 2003 - 03:47 AM

thanks for replying.

i read a few tutorials on FULLTEXT and went ahead with implementing it. it works fine (unusual for me) so I don\'t think I\'m going to try LIKE.

adios.
Guru?...in my dreams!
Sorry Everybody

----------------------




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users