MySQL Forums
Forum List  »  Full-Text Search

Full-text search of exact phrase problem
Posted by: Lukas Pilny
Date: October 11, 2007 03:35PM

Hi MySQL DB friends,

I'm trying to build full-text search in genealogy database. I'm using table, where each person has fullname splitted into two cols - first_name, last_name. The problem came when I'm trying to search exact fullname (IN BOOLEAN MODE), e.g. '"Helena Hartlova"'.

The way the full-text is made, takes MATCH(first_name,last_name) AGAINST('"Helena Hartlova"' IN BOOLEAN MODE) , so it doesn´t find anything, because there´s not such a name in first_name, or in last_name.

First I thought it will be possible to use CONCAT in MATCH(), but nonsense!

Then I even try to create VIEW, where I CONCAT(first_name,' ',lname) AS fullname and run the full-text search there, but no success too.

Does anybody have an idea how can I fix this first name, last name, full name conflict?? Or do I have to make additional column ´fullname´ for each record??

Thanks a lot in advance for any advice.

Options: ReplyQuote

Written By
Full-text search of exact phrase problem
October 11, 2007 03:35PM

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.