How to find out the record number in sql query when sorting by some parameter?

Question

MySQL

There is a user table users in which there is a score field - experience points. You need to sort by this parameter (score) and find where in this sorting the user with some specific id is located (there is an id field in the table). That is, as a result of the request, we should get one number. How to do it?

Answer 1

Where is the user in the rating?
On how many people are in front of him.
select count where score < (select score where id = :curuser)

Answer 2

stackoverflow.com/questions/3333665/rank-function-...