Thursday, November 8, 2007

Fulltext Search in MySQL

There are some points I encountered during my experiements:
1. how to change ft_min_word_len for windows platform: add one line ft_min_word_len = 2 in my.ini file in MySQL installment directory

2. After we changed the ft_min_word_len variable, we have to rebuild the fulltext index by ALTER TABLE person ADD FULLTEXT(name)

No comments: