Re: Full-text search of exact phrase problem
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
Subject
Views
Written By
Posted
12700
October 11, 2007 03:35PM
6192
October 25, 2007 06:44AM
Re: Full-text search of exact phrase problem
5470
October 28, 2007 08:03AM
5224
October 29, 2007 04:19AM
6416
October 30, 2007 12:25PM
5574
November 01, 2007 06:16AM
5032
November 03, 2007 03:03PM
4448
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.