mgm_03 Posted August 29, 2003 Share Posted August 29, 2003 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! Quote Link to comment https://forums.phpfreaks.com/topic/957-search-fulltex-or-like/ Share on other sites More sharing options...
McGruff Posted September 3, 2003 Share Posted September 3, 2003 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. Quote Link to comment https://forums.phpfreaks.com/topic/957-search-fulltex-or-like/#findComment-3313 Share on other sites More sharing options...
mgm_03 Posted September 4, 2003 Author Share Posted September 4, 2003 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. Quote Link to comment https://forums.phpfreaks.com/topic/957-search-fulltex-or-like/#findComment-3320 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.