Search: FULLTEX or LIKE ?
Posted 29 August 2003 - 06:07 PM
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?
Posted 03 September 2003 - 09:05 PM
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.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users