Hi,
i have a enewsletter list with 6000 email addresses. I want to write a query to send a batch of say 2500 each rather than all at the same time. Ive been trying to use the Limit function but it is not behaving as expected.

if i do this

SELECT * from subscribers WHERE active='1' LIMIT 0,2500"

it returns the first 2500. but when i do another query below it

SELECT * from subscribers WHERE active='1' LIMIT 2500, 5000"

it returns all of the results from 2500 to the full 6000. Why is it not stopping at 5000?

any help appreciated