Help with using MAX to find highest value

[Robert Vrabel]

I'm trying to write a query to find the records with the highest value based off a ID

To simplify the table lets say it is song_id, user_id, date_completed, score

I'm trying to do something simliar to this to return the highest values for each song where the user_id is set to something.

SELECT `song_stats`.*, MAX(score) as max_score FROM `song_stats` WHERE `user_id` = '1' GROUP BY `song_id

The problem with this query is its not returning the actual record where the score is the highest, it is just placing a max_score field in addition to the first field it finds when it does the group by. So my problem is the date_completed field (and all the other fields not mentioned) is not accurate when I get the returned records.

How can I write something simliar to this, but return the EXACT full record of the highest score for each song?