returning limited range of results

[cleromancer]

I have a query that I want to return a set range of results from.

This query returns 100 users:
select * from users

I want to get them 10 at a time, ie:
select "results 10 to 20" from users
select "results 20 to 30" from users
select "results 30 to 40" from users
select "results 40 to 50" from users

is there any way to do this?

[[deleted]]

If you are using MySQL:

select from users LIMIT 0,10
select from users LIMIT 10,10
select from users LIMIT 20,10
select from users LIMIT 30,10

etc