MySQL - 无限制地启动[重复]

Question

This question already has an answer here:

• MySQL offset infinite rows 8 answers

I have the following SQL code;

    SELECT * FROM myTable WHERE id = 1 LIMIT 4, 10;

I would like the sql to run from result 4 but have no end limit, so I would like the script to get all the results from 4 onwards. Is this possible?

Any help appreciated.

</div>

Answer 1

You can use the OFFSET option in your query. Like this

SELECT * 
FROM myTable 
WHERE id = 1
OFFSET 4