获取MYSQL查询中的行位置 [英] Get row position in MYSQL query

问题描述

可能重复:
MySQL中的ROW_NUMBER()

这可能吗?我想按特定顺序获得一堆结果，然后通过其ID找出行的位置，例如:

1, foo
2, bar
3, foobar

我想按字母顺序获得1的位置，它将返回2

解决方案

SELECT id, name, rank FROM 
    (
    SELECT t.id, t.name,
        @rownum := @rownum + 1 AS rank
    FROM TABLE t, (SELECT @rownum := 0) r
    ORDER BY name ASC
    ) `selection` WHERE id=1

根据此答案进行了修改>> MySQL中的ROW_NUMBER()

Possible Duplicate:
ROW_NUMBER() in MySQL

Is this possible? I want to get a bunch of results in a specific order and then find out the position of a row by its id, for example:

1, foo
2, bar
3, foobar

I want to get the position of 1 in Alphabetical order, it would return 2

解决方案

SELECT id, name, rank FROM 
    (
    SELECT t.id, t.name,
        @rownum := @rownum + 1 AS rank
    FROM TABLE t, (SELECT @rownum := 0) r
    ORDER BY name ASC
    ) `selection` WHERE id=1

Modified from this answer >> ROW_NUMBER() in MySQL

这篇关于获取MYSQL查询中的行位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！