CODEWITHSUNDEEP
mysqlfull-text-search
1Mayur
1Mayur

Reputation: 3485

Full text search in mysql not giving what I want

I have implemented full text search on two fields (title, description)

now if I search for chelsea in it gives me right result but when i search for Manchester city then it give all the result where title/description contains manchester or city

ex Manchester city gives me result manchester united hull city conventry city etc

below is my query

SELECT DISTINCT * FROM news WHERE MATCH (title, description) AGAINST (:search)

Upvotes: 0

Views: 56

Answers (1)

Lefteris Bab
Lefteris Bab

Reputation: 787

Yes you have to add Fulltext index see this and then write something like:

SELECT * FROM patient_db WHERE MATCH ( Name, id_number ) AGAINST ('+first_word +second_word +third_word' IN BOOLEAN MODE);

Upvotes: 1

Related Questions