[Solved] PHP/MYSQL – Limit to last 500 then continue

by


If you don’t want to update the records, use the full version of the LIMIT clause.

SELECT ... FROM tweets WHERE ... LIMIT 1 500
SELECT ... FROM tweets WHERE ... LIMIT 501 500
SELECT ... FROM tweets WHERE ... LIMIT 1001 500

of course, this will mean you need to keep track of which block you last retrieved.

0

solved PHP/MYSQL – Limit to last 500 then continue