MySQL Forums
Forum List  »  Full-Text Search

User must decide to choose case-sensitive or insentive query
Posted by: Fco. Mario Barcala Rodríguez
Date: November 03, 2008 04:24AM

I want my application users could decide if their queries are case-sensitive or case-insensitive over a FULLTEXT column. Is there any other solution different to duplicate the column data and build different fulltext indexes for both (one case-sensitive and other case-insensitive)?

Is there any way to build two indexes ant the same FULLTEXT column and decide which one to use in the query?

Thank you,

Mario Barcala

Options: ReplyQuote


Subject
Views
Written By
Posted
User must decide to choose case-sensitive or insentive query
4875
November 03, 2008 04:24AM


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.