MySQL Forums
Forum List  »  Full-Text Search

very weird FULLTEXT OR BOOLEAN SEARCH BUG
Posted by: Gwen Guer
Date: April 17, 2009 05:32AM

Hello,

This is my first post on this forum but I'm a MySql user for 7 years now

I do have a very weird problem with the following query

SELECT DISTINCT a.`product_name`,
MATCH ( product_name)
AGAINST ('Fur'IN BOOLEAN MODE) AS score
FROM table_product a
WHERE MATCH (product_name )
AGAINST ('+Fur*'IN BOOLEAN MODE)

a lot of product_name should be found on our table like
white fur
red fur
etc...

The Query is ok and works very well on other research like 'red tee', 'shirt green sleeves', etc...
no problem for this
the problem is ONLY on the keyword FUR, wich means "with" in german, or "fourrure" in french

*********************************
I was wondering if "fur" was not a reserve word for mysql or something like this
*********************************

Any idea on this bug ?

Options: ReplyQuote


Subject
Views
Written By
Posted
very weird FULLTEXT OR BOOLEAN SEARCH BUG
4682
April 17, 2009 05:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.