Re: Full-text search of exact phrase problem

[Lukas Pilny]

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