Here is my query:

SELECT distinct user, keyword FROM searches WHERE MATCH (keyword) AGAINST ('Lavender helped my sore jaw') order by user

This produces a listing of searches conducted by my website users, including many duplicates. For example, user # 110 may have conducted three searches that each meet the criteria of my query:

110 - lavender uses
110 - sore legs
110 - jaw surgery

How come distinct is not working in this particular case? I want to send out one email notification to user # 110, not three emails.