80行数据，首先选择1-20行，第二行选择21-30行

Question

I have a table containing rows with timestamped.

Normally if I want to get the latest 20 rows out according to the time. I use:

$sql = "SELECT * 
    FROM comment 
    ORDER BY time DESC 
    LIMIT 20";

But now, I want to get the latest comments AFTER the latest 20 rows and LIMIT to 10. That means rows 21-30.(of course , everything is according to timestamp)

How can I do that using MySQL?

Answer 1

MySQL has a built-in offset that you can use with LIMIT:

$sql = "SELECT * FROM comment ORDER BY time DESC LIMIT 10, 20";

Also, refer to this SO post: MySQL LIMIT/OFFSET: get all records except the first X