RANK in SELECT (using variable)
SELECT id, name, @curRank := @curRank + 1 AS rank
FROM image, (SELECT @curRank := -1) r
ORDER BY id;
id | name | rank | @curRank := -1 | rank |
---|---|---|---|---|
120 | First | 0 | -1 | 0 |
121 | Second | 0 | -1 | 1 |
122 | Third | 7 | -1 | 3 |
123 | Fourth | 8 | -1 | 4 |