Rank

[Anon]

Is there some sort of rank function for MySQL? I couldn't find anything in the manual. What I want to do is return the rank based on a column, for example:

id numberofwhatever
4 434
5 490
9 453
10 500

RANK(4) would return 4, RANK(5) would return 2, RANK(10) returns 1, etc.

[georgen]

set @t=0;
select @t:@t+1 as rank, id from your_table order by id desc; this will return:

rank id
1 10
2 5
3 9
4 4

[Anon]

I don't understand that at all... :\