Query: finding lastest 6, but then the 6 before that?

[elck]

It is easy to find the latest 6 entries I think, something with limit I presume and order DESC?

But how do I find the 6 before the 6 latest?
and then back until to first?

Sorry, but I am still very much a beginner at this.

(I have an auto-increment integer(=ID) and a timestamp field)

 

[TonyGroves]

To get the latest 6:[tt]
ORDER BY fld DESC LIMIT 6[/tt]
To get the next 6:[tt]
ORDER BY fld DESC LIMIT 6,6[/tt]
To get the rest:[tt]
ORDER BY fld DESC LIMIT 12,99999[/tt]

 

[elck]

Thanks Tony I think I get it.