MySQL Noob Question
How do I get the in index of a row?
Code:
+-----+------+
| id | xp |
+-----+------+
| 4 | 10 |
+-----+------+
| 1 | 15 |
+-----+------+
| 2 | 5 |
+-----+------+
| 3 | 40 |
+-----+------+
How would I find how many rows down 'id' "2" is? (it should be 3, if you start from 1)
__________________