Date: 02/08/07 (MySQL Communtiy)    Keywords: database

Let's say I have a message IDs like this sequence extracted from a database.

1
2
3
4
5
6
7
8
9
10
27
28
29
30
39
45
58
59
60
63

If I want to select the first 10 data, it's easy with LIMIT 0,10.

But, how do I select the second 10 data when it goes random? And third and fourth and the rest?

Is there a simpler way than putting out the last ID in a cookie?

Source: http://community.livejournal.com/mysql/109090.html