> * Searching "New England" brings up all entries with "england", > regardless of new. > * Changing the stoplist to blank (and doing a "REPAIR TABLE") > generates the same results. > * Also changing it to a blank custom stopword list has the same results. > * Searching only on "New" finds no entry (even though it's in there). > * Searching on "The" gets the same. Changing the custom stopword list > to include "England" makes the "New England" serach come up blank.
You need to set the global variable ft_min_word_len to 3 to achieve what you want. As shipped, it is set to 4, which means that words of three or less letters are ignored. After changing the variable, you need to rebuild the index. Alec Cawley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
