MySQL Forums
Forum List  »  Full-Text Search

Ignoring some characters to build FULLTEXT index
Posted by: Fco. Mario Barcala Rodríguez
Date: October 21, 2008 06:20AM

Hi all:

I am trying to build a FULLTEXT index with several particularities. It
must ignore some special characters inside index words. For example:

If I have the text:

I'll go to the ci[ne]ma.

I want the FULLTEXT include the word cinema, not ci[ne]ma nor ci or ne or
ma. So, I want the index ignore [ and ] to build the index. Is what in
Oracle nomenclature names skipjoins.

I know I can modify which characters can ben part of a word throw
true_word_char() or misc_word_char() but, what about this behaviour? Is
it possible to tell my sql to ignore some character for building the

I am testing this in mysql 5.0 and 5.1

Thanks in advance,

Mario Barcala

Options: ReplyQuote

Written By
Ignoring some characters to build FULLTEXT index
October 21, 2008 06:20AM

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.