Thursday, August 11, 2005

MYSQL Full Text index stop words

One potentially annoying bit about full-text index searching on MySQL is the minimum word length. The English language abounds with meaningful three-character nouns. Our database contains a few of them, like war and dog. MYSQL considers these stop words and excludes them from a search. The default configuration (4+ character words are searchable) can be changed by modifying the ft_min_word_len system variable.

0 Comments:

Post a Comment

<< Home