MySQL - rows limit with offset

In this short article, we would like to show how to get rows from table using LIMIT and OFFSET in MySQL query.

LIMIT and OFFSET should be placed always as last.

Quick solution:

xxxxxxxxxx

SELECT *

FROM users

LIMIT 5 OFFSET 10;

Where: OFFSET is counted starting from 0 (it means to get first row from table we need to use OFFSET 0).

The same query can be written using shorter form:

xxxxxxxxxx

SELECT *

FROM users

LIMIT 10, 5;

Result:

• 5 users (LIMIT is 5),
• starting from 10th position (OFFSET is 10).

xxxxxxxxxx

SELECT u.*, m.*

FROM users u

JOIN messages m

ORDER BY m.id ASC

LIMIT 10, 5;