Displaying a single rank in MySQL table
- by MichaelInno
I have a table called 'highscores' that looks like this.
id udid name score
1 1111 Mike 200
2 3333 Joe 300
3 4444 Billy 50
4 0000 Loser 10
5 DDDD Face 400
Given a specific udid, I want to return the rank of that row by their score value.
i.e. if udid given = 0000, I should return 5.
Any idea how to write this query for a MySQL database?
