MySQL Forums
Forum List  »  Full-Text Search

Should I bother with FTS in my situation?
Posted by: Max Arbos
Date: September 13, 2010 07:34AM


I have a table that contains a few varchar columns. I want someone to be able to search for results that have terms in them that they enter but they are only allowed to search one column at a time.
So if i am looking for 'red', I would choose 'Color' from a drop down list that would then tell the query to only search that column.
Right now, that search would return 'red', 'reddish', 'red-green', etc..

Things work great now with FTI on each column, but I am now wanting to be able to allow a wildcard at the front and back of the search term so results like: 'bluered', dark-red', etc..would also be returned. FTS only allows it at the end, and since I am only searching a column at a time, is it really worth it to even bother with the FTI search method to get the function i want?


Options: ReplyQuote

Written By
Should I bother with FTS in my situation?
September 13, 2010 07:34AM

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.