[RESOLVED] WHERE MATCH - unexpected results

[baffled_in_UK]

Hello,

has anybody any idea why this happens?

prod_search has this value - the best dance album in the world ever

SELECT * FROM `products` WHERE MATCH (prod_search) AGAINST ('best')

This returns no records

SELECT * FROM `products` WHERE MATCH (prod_search) AGAINST ('album')

This returns records

prod_search is a field specfied as a FULLTEXT index

Now I thought the limitation was 3 characters not 4?

Can anybody help?

Thanks

[Piranha]

In the manual you can see that the word "best" is a stopword, and won't be searched for. You can read more about it here, and there are solutions here. I am amazed that it only took about 5 minutes to find this out using google, I didn't know anything about fulltext searches before this question.

[baffled_in_UK]

Thank you.

The list of stopwords is very restrictive (I didn't think there would be so many).
Looks like I'll have to forget about MATCH and try something else as I can't change the SQL settings.

Thank you for the response.