mysql - select pagination chunk that includes a given id
- by sean smith
...before the pagination chunks have been determined.
I know you can do this in multiple statements, but there must be a better way.
my results are returned ordered by date and I want to return the pagination chunk that contains a given id. So I could, for example, select the date of the given id and then select a chunk of results where date…