Results 1 to 3 of 3
Dec 18, 2008, 03:26 #1
- Join Date
- Jan 2005
- Hiding from the world
- 0 Post(s)
- 0 Thread(s)
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 appreciatedIf i am a product of your imagination you should try harder!