Re: Fulltext Match BOOLEAN MODE not searching integers

2010-03-31 Thread Tompkins Neil
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 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

Re: Fulltext Match BOOLEAN MODE not searching integers

2010-03-31 Thread Tompkins Neil
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 wrote: > On 31/03/2010 16:52, Tompkins Neil wrote: > >> Hi >> >> I have the following

Re: Fulltext Match BOOLEAN MODE not searching integers

2010-03-31 Thread Mark Goodge
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 r

Fulltext Match BOOLEAN MODE not searching integers

2010-03-31 Thread Tompkins Neil
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