using the limit function - doesnt seem to have an effect on my query
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