Fulltext Match BOOLEAN MODE not searching integers

--00151747857cf35fd304831abb75
Content-Type: text/plain; charset=ISO-8859-1

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 ?

Thanks,
Neil

--00151747857cf35fd304831abb75--

Re: Fulltext Match BOOLEAN MODE not searching integers

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=gcdmg-mysql-2@m.gmane.org

Re: Fulltext Match BOOLEAN MODE not searching integers

--001517447f403c9f1904831b6111
Content-Type: text/plain; charset=ISO-8859-1

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 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.tompkins@googlemail. com
>
>

--001517447f403c9f1904831b6111--

Re: Fulltext Match BOOLEAN MODE not searching integers

--00151747857cb0224404831ba1b9
Content-Type: text/plain; charset=ISO-8859-1

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
> 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 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.tompkins@googlemail. com
>>
>>
>

--00151747857cb0224404831ba1b9--