limiting rows returned based on count

[keak]

Hi there,
say if I have 3000 records in my db,
and I want to get rows 200~300 when orderd by a specific field in this table, is there a easy way to do it?

I have something like
select * from table_name order by ID desc limit ....

but I am not sure if this syntax allows me to do what I am trying to do .

 

[TonyGroves]

You could use:[tt]
LIMIT 199,100[/tt]
which will skip the first 199 records and return the next 100.