mysql查询自己的排名

SELECT b.id,b.uid,b.nickname,b.like,b.head,b.img,b.content,b.status, b.ranking FROM (SELECT t.*, @ranking := @ranking + 1 AS ranking FROM (SELECT @ranking := 0) r,
                    (SELECT id,nickname,uid,`like`, head,img,content, status FROM tp_blessing WHERE status=1 ORDER BY `like` DESC) AS t) AS b WHERE  b.status=1 AND b.uid={$uid} 

 

posted @ 2022-02-08 17:57  Abner3721  阅读(605)  评论(0编辑  收藏  举报