MySQL Forums
Forum List  »  Full-Text Search

Re: full text and word cutting
Posted by: Martyn Coupland
Date: June 11, 2005 12:39PM

Quote [Jeff Smith]:

Keep in mind that although MATCH() AGAINST() is case-insensitive, it also is basically **accent-insensitive**. In other words, if you do not want _mang韠to match with _mange_ (this example is in French), you have no choice but to use the BOOLEAN MODE with the double quote operator. This is the only way that MATCH() AGAINST() will make accent-sensitive matches.


SELECT * FROM quotes_table WHERE MATCH (quote) AGAINST ('"mang馱uot;' IN BOOLEAN MODE)

For multiword searches:

SELECT * FROM quotes_table MATCH (quote) AGAINST ('"mang馱uot; "pens馱uot;' IN BOOLEAN MODE)

SELECT * FROM quotes_table MATCH (quote) AGAINST ('+"mang馱uot; +"pens馱uot;' IN BOOLEAN MODE)

Although the double quotes are intended to enable phrase searching, just like any web search engine for example, you can also use them to signify single words where accents and other diacritics matter.

The only drawback to this method seems to be that the asterisk operator is mutually exclusive with the double quote. Or I just haven't been able to combine both effectively.

Taken from Second comment.

Martyn Coupland
Development Officer

Options: ReplyQuote

Written By
May 31, 2005 02:56AM
Re: full text and word cutting
June 11, 2005 12:39PM

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.