I would like use the
OFFSET in a SELECT query so I can use pagination in my webapplication. The only problem is I only know the ID of the row from which I would like to start, not the actually OFFSET. An ID looks like this:
So what I do, I SELECT all results from a table and ORDER it by the
created_at column and set the LIMIT to a certain value. Now I only know the last ID I get returned, so I would like to start the next page from that ID.
Anyone who knows an easy way to accomplish this using a MySQL query?