MySQL Forums
Forum List  »  Full-Text Search

Full-Text Search Across Multiple Fields
Posted by: Michael Lawson
Date: August 20, 2015 05:02PM

I have three fields defined as fulltext: name, address, city

SELECT * FROM TALBE WHERE MATCH(name, address, city) AGAINST ('QUERY' IN BOOLEAN MODE)

If I had the records:
1) James Smith | 123 Anywhere Ave | Springfield
2) Jane Smith | 456 James Ct | Smithville

If I query on "Springfield +James" I would expect to get back JUST #1, but I am getting 1 and 2. Can somebody please explain why, when I request Springfield AND James, I get #2 which only has James?

Options: ReplyQuote


Subject
Views
Written By
Posted
Full-Text Search Across Multiple Fields
2925
August 20, 2015 05:02PM


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.