The question title says it all. basically i have a list of scores, i want to select them in order and add a rank column to the result. something like this:
SELECT score, CURRENT_ROW as 'rank'
ORDER BY score
i don't think CURRENT_ROW is actually a variable in MySQL. I need to know what to use in it's place