Need some help with using DISTINCT
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.