Re: Using FULLTEXT index with a boolean on the matched field?
Posted by:
Roy Nasser
Date: September 09, 2009 07:53AM
Ok. Lets try again.
Index includes "sweet pie"
Search phrase:
apple sweet pie - matches
apple pie - dont match
sweet apple pie - matchs but lowrr than first
i got this result (almost) by using locate() after the full text matching, to remove the matches that didnt include the entire phrase, but this means that locate only matches entire phrase in the exact order, whereas fulltext would be more "forgiving"?
Basically, i want to specify that all words in the index are required to be present in te search term.
I hope it us easier to understand.
Subject
Written By
Posted
September 08, 2009 03:18PM
September 09, 2009 03:44AM
Re: Using FULLTEXT index with a boolean on the matched field?
September 09, 2009 07:53AM
September 09, 2009 09:31AM
September 09, 2009 09:54AM
September 09, 2009 09:52AM
September 09, 2009 10:34AM
September 09, 2009 11:02AM
September 09, 2009 03:20PM
September 10, 2009 12:49AM
September 10, 2009 03:05AM
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.