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

This question already has an answer here:

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>

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

SELECT * 
FROM myTable 
WHERE id = 1
OFFSET 4
SELECT * FROM tbl LIMIT 4, 18446744073709551615;

resource mysql docs.