Should I bother with FTS in my situation?
Posted by:
Max Arbos
Date: September 13, 2010 07:34AM
Hello,
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?
thanks.
Subject
Views
Written By
Posted
Should I bother with FTS in my situation?
3303
September 13, 2010 07:34AM
1671
September 16, 2010 09:48PM
1630
September 17, 2010 07:33AM
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.