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

« Updating multiple rows || New good project »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home