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: Lukas Pilny ()
Date: October 28, 2007 08:03AM

Thanks for reply Anton, but it´s not sure that Helena is first_name (when I use user's input), than I would have to do the HAVING clause like :
HAVING (first_name = "Helena" AND last_name = "Hartlova") OR (first_name = "Hartlova" AND last_name = "Helena"), I guess it would slow down the search too much. I finally decided for making the additional column full_name instead.
But if anybody knows how to make it better, I would appreciate it still.

Thank you

Options: ReplyQuote


Subject Views Written By Posted
Full-text search of exact phrase problem 10976 Lukas Pilny 10/11/2007 03:35PM
Re: Full-text search of exact phrase problem 5471 Anton Staykov 10/25/2007 06:44AM
Re: Full-text search of exact phrase problem 4748 Lukas Pilny 10/28/2007 08:03AM
Re: Full-text search of exact phrase problem 4439 Anton Staykov 10/29/2007 04:19AM
Re: Full-text search of exact phrase problem 5611 Lukas Pilny 10/30/2007 12:25PM
Re: Full-text search of exact phrase problem 4822 Anton Staykov 11/01/2007 06:16AM
Re: Full-text search of exact phrase problem 4343 Lukas Pilny 11/03/2007 03:03PM
Re: Full-text search of exact phrase problem 3936 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.