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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]