Re: Finding a record's position when sorted

[toasty]

That works in simple cases, but not if the ORDER BY is complex, like:

SELECT * FROM tbl ORDER BY popularity, purchases;


I know I could do something like "WHERE ((popularity*100000)+purchases)>@var" but that's kinda messy. It also wouldn't work if one of the ORDER BY terms was ASC and the other DESC.


I don't remember which database system allowed this, but I remember doing something like:

SELECT * FROM tbl HAVING internal_row=500 ORDER BY popularity;

to use an internal/hidden row ID number that's added to each row after ORDER BY has finished its sort.

Is there anything similar in MySQL?