Problem with MySQL Full-Text Search

[Jassim Rahma]

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