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 <m...@good-stuff.co.uk> 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/mysql?unsub=neil.tompk...@googlemail.com
>
>
