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
index?

I am testing this in mysql 5.0 and 5.1

Thanks in advance,

Mario Barcala

Options: ReplyQuote


Subject
Views
Written By
Posted
Ignoring some characters to build FULLTEXT index
6001
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.