MySQL limit from descending order
10:35 25 Apr 2010

Is it available to write a query to use same "LIMIT (from), (count)", but get result in backwards?

In example if I have 8 rows in the table and I want to get 5 rows in two steps I would: first step query:

select * from table limit 0, 5

first step result:

first 5 rows;

second step query:

select * from table limit 5, 5

second step result:

last 3 rows;

But I want to get it vice versa. I mean from the first step I want last 3 rows and from the second I want 5 first rows. Thank you for your answer

mysql limit