MYSQL full text search

[Yogesh Sarkar]

How does one reduces the minimum number of characters in MYSQL full text search? Currently it is set to four and I want to reduce it to 3.

Ps. I mean on the MYSQL server, not on the VB.

[TECK]

[mysqld]
ft_min_word_len = 3
ft_max_word_len = 20

Edit: Then you must restart the server and rebuild your FULLTEXT indexes.

[Yogesh Sarkar]

Thanks Teck