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.
Kind regards, Taco Fleur 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! -----Original Message----- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 April 2006 3:56 AM To: Taco Fleur Cc: mysql@lists.mysql.com 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 indexed. http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]