Re: Full-text search of exact phrase problem
Something that would help is to put HAVING clause, although I have experienced some strange behaviors of this clause in conjunction with fulltext.
So try do extend your query to:
MATCH(first_name,last_name) AGAINST('"Helena Hartlova"' IN BOOLEAN MODE)
HAVING first_name="Helena" AND last_name = "Hartlova"
This might help with the cost of applying HAVING clause.
Subject
Views
Written By
Posted
12900
October 11, 2007 03:35PM
Re: Full-text search of exact phrase problem
6294
October 25, 2007 06:44AM
5572
October 28, 2007 08:03AM
5325
October 29, 2007 04:19AM
6535
October 30, 2007 12:25PM
5710
November 01, 2007 06:16AM
5141
November 03, 2007 03:03PM
4567
November 08, 2007 04:14AM
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.