I should know this really, but never mind.
I've got a select statement e.g:
I need to find out what row number a value in column1 is in.Code:SELECT column1 FROM table ORDER BY column1 desc
If the data returned was this:
I would need to know that value4 is on row 3 (as MySQL counts from 0).
I could do some PHP loops although I'm sure that there is a simple MySQL statement to do what I need.