Skip navigation links

MySQL Forums :: Full-Text Search :: Full-text search of exact phrase problem


Advanced Search

Re: Full-text search of exact phrase problem
Posted by: Anton Staykov ()
Date: October 25, 2007 06:44AM

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.

Options: ReplyQuote


Subject Views Written By Posted
Full-text search of exact phrase problem 11438 Lukas Pilny 10/11/2007 03:35PM
Re: Full-text search of exact phrase problem 5669 Anton Staykov 10/25/2007 06:44AM
Re: Full-text search of exact phrase problem 4940 Lukas Pilny 10/28/2007 08:03AM
Re: Full-text search of exact phrase problem 4638 Anton Staykov 10/29/2007 04:19AM
Re: Full-text search of exact phrase problem 5820 Lukas Pilny 10/30/2007 12:25PM
Re: Full-text search of exact phrase problem 5003 Anton Staykov 11/01/2007 06:16AM
Re: Full-text search of exact phrase problem 4536 Lukas Pilny 11/03/2007 03:03PM
Re: Full-text search of exact phrase problem 4030 Anton Staykov 11/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.