Mysql 查询用户排行名次

SELECT * FROM (SELECT user_id,(@rowNum:=@rowNum+1) AS rowNo FROM tab_users,(SELECT (@rowNum :=0) ) b ORDER BY age DESC) c WHERE user_id=216;