MySQL query won't return any rows when adding OFFSET [duplicate]

Question

Trying to add offset to a mysqli query, but it won't return any rows:

Works:

SELECT * FROM posts WHERE published='1' ORDER BY id DESC

Does not work:

SELECT * FROM posts WHERE published='1' ORDER BY id DESC OFFSET 20

CodingLife · Accepted Answer · 2020-11-28 20:23:24Z

2

You can try this syntax instead as OFFSET needs LIMIT keyword:

SELECT * FROM posts WHERE published='1' ORDER BY id DESC LIMIT 40 OFFSET 20;

This means that it will return the limit of fetched rows 40 only and skipping the first 20 rows.

answered Nov 28, 2020 at 20:23

CodingLife

3681 gold badge4 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1