I have changed a fulltext variable ft_min_word_len from the default 4 to 1, and the manual says to rebuild my fulltext indexes once again. I verified that this variable changed with SHOW VARIABLES and it did change.
I have tried optimize table, analyze table, repair table which all finished without errors and very quickly, but When I try a new simple query I can see that the index was not rebuilt. I search for the word '+the*' which shows up in about every record. I didn't get any records back earlier because my ft_min_word_len was too high. but I still do not get any records. Does anyone know what I am doing wrong? -- _____________________ Jason Kushmaul, Software Engineer WirelessDeveloper.com Suite 200 2875 Northwind Drive East Lansing, MI 48823 [EMAIL PROTECTED] (517)337-2701 ext. 205 Become a Member Today!! http://www.WirelessDeveloper.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php