MySQL Forums
Forum List  »  Full-Text Search

Problem with MySQL Full-Text Search
Posted by: Jassim Rahma
Date: July 29, 2012 02:50PM

I am using the following statement:

SELECT * FROM patients WHERE MATCH(full_name) AGAINST('jassim ali' WITH QUERY EXPANSION) ORDER BY full_name;

what I want to display all records contains jassim and should also contains ali but getting totally different result! here are names I am getting in the result:

Abdul Rahma Salma
Ali Jassim
Jassim Rahma
Jassim Rahma
Mohd Ali Ahmed
Mohd Jassim Maki

Options: ReplyQuote

Written By
Problem with MySQL Full-Text Search
July 29, 2012 02:50PM

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.