find mysql number

I want to select one row out of a very long list, and I want a numerical rank based on the column 'points'

i want to:
select name from players_attack where name='$name'

now how would i figure out where in the rankings?

 

 

 

 

Top