Jump to content

Archived

This topic is now archived and is closed to further replies.

mgm_03

Search: FULLTEX or LIKE ?

Recommended Posts

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!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.