limiting data fetched
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