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 ?
Subject
Views
Written By
Posted
very weird FULLTEXT OR BOOLEAN SEARCH BUG
4791
April 17, 2009 05:32AM
2933
May 01, 2009 11:56PM
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.