Return to Answer

Mysql supports the ROW_NUMBER() function.

SELECT rank
FROM (
    SELECT ROW_NUMBER() OVER () AS rank, meta_key, meta_value, post_id
    FROM wp_postmeta
    WHERE meta_key = 'points'
    ORDER BY meta_value
) AS r
WHERE post_id = 18;

But I'm not sure it performs any better than your solution.

Mysql supports the ROW_NUMBER() function.

SELECT rank
FROM (
    SELECT ROW_NUMBER() OVER (ORDER BY meta_value) AS rank,
        meta_key, meta_value, post_id
    FROM wp_postmeta
    WHERE meta_key = 'points'
) AS r
WHERE post_id = 18;

But I'm not sure it performs any better than your solution.

Mysql supports the ROW_NUMBER() function.

SELECT rank
FROM (
    SELECT ROW_NUMBER() OVER () AS rank, meta_key, meta_value, post_id
    FROM wp_postmeta
    WHERE meta_key = 'points'
) AS r
WHERE post_id = 18;

Mysql supports the ROW_NUMBER() function.

SELECT rank
FROM (
    SELECT ROW_NUMBER() OVER () AS rank, meta_key, meta_value, post_id
    FROM wp_postmeta
    WHERE meta_key = 'points'
    ORDER BY meta_value
) AS r
WHERE post_id = 18;

But I'm not sure it performs any better than your solution.

Mysql supports the ROW_NUMBER() function.

SELECT ROW_NUMBER() OVER () AS rank, meta_key, meta_value, post_id
FROM wp_postmeta
WHERE meta_key = 'points';


+------+----------+------------+---------+
| rank | meta_key | meta_value | post_id |
+------+----------+------------+---------+
|    1 | points   |         12 |      23 |
|    2 | points   |          2 |      18 |
|    3 | points   |          8 |      15 |
+------+----------+------------+---------+
```

Mysql supports the ROW_NUMBER() function.

SELECT rank
FROM (
    SELECT ROW_NUMBER() OVER () AS rank, meta_key, meta_value, post_id
    FROM wp_postmeta
    WHERE meta_key = 'points'
) AS r
WHERE post_id = 18;