Hi I found by using the REPAIR command it is now working.
Thanks, Neil On Wed, Mar 31, 2010 at 5:38 PM, Tompkins Neil <[email protected] > wrote: > Hi Mark > > I did infact change the value of ft_min_word_len to 1. Rebuild the indexes > using REPAIR table name. But it didn't appear to have any affect. > > Cheers > Neil > > On Wed, Mar 31, 2010 at 5:29 PM, Mark Goodge <[email protected]>wrote: > >> On 31/03/2010 16:52, Tompkins Neil wrote: >> >>> Hi >>> >>> I have the following fulltext search which appears to work fine for >>> string >>> phrases. However if I search like just "51" which is part of the string >>> name like 51 Blue Widget in the table it doesn't return any results. >>> However if I search like "bl" it returns the 51 Blue Widget result. My >>> query is as follows : >>> >>> SELECT Name MATCH (Name) AGAINST ('51*') as Relevance >>> FROM Products >>> WHERE MATCH (Name) AGAINST ('51*' IN BOOLEAN MODE) >>> ORDER BY Relevance DESC >>> >>> Any ideas what the problem might be ? >>> >> >> "51" is too short to be included in the index by default, so will never >> match. "Blue", on the other hand, is indexed and therefore is returned by a >> search. >> >> The default minimum word length is four characters. See >> http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html for more >> information on how to change that if necessary. >> >> Mark >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[email protected] >> >> >
