Thanks for that, you saved the day.
I am now trying to change that variable, I did a search through the ini
files and changed the only file that had ft_min_word_len in it to
ft_min_word_len = 2 restarted the server did SHOW VARIABLES and it still
shows as 4, not sure what I am missing, going through the documentation but
just can't find anything specific.
Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox http://www.pacificfox.com.au an industry leader with commercial
IT experience since 1994 .
Web Design and Development
SMS Solutions, including developer API
Domain Registration, .COM for as low as fifteen dollars a year,
.COM.AU for fifty dollars two years!
From: Dan Nelson [mailto:dnelson@stripped]
Sent: Thursday, 13 April 2006 3:56 AM
To: Taco Fleur
Subject: Re: Fulltext and reserved words
In the last episode (Apr 12), Taco Fleur said:
> I am in need to search for sql reserved words with MATCH AGAINST it
> turns it doesn't return anything when I feed it a reserved word like
> 'sql' is there anything I can do about that?
By default the full-text indexer skips words less than four characters long.
If you set ft_min_word_len=3 and rebuild your index, "sql" should get
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql