I am implementing pagination using Sql limit in mysql and i want to retrieve records from the last row backwards. There are several thousands records in table
and i want to retrieve say 500 records at a time to show up in a page.
If i use "select * from tbl_name order by some_col desc limit 500" it will return
last 500 records in descending order.
but i could not find a way to retrieve next block of 500 in reverse direction,
starting from a point where first block have left up.