PDA

View Full Version : MYSQL full text search


Yogesh Sarkar
13 Apr 2008, 05:35
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
13 Apr 2008, 07:40
[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
13 Apr 2008, 14:45
Thanks Teck