Full-Text Search Across Multiple Fields
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?
Subject
Views
Written By
Posted
Full-Text Search Across Multiple Fields
3190
August 20, 2015 05:02PM
2884
August 22, 2015 01:15PM
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.