This question has already been answered:

There is a table with a large number of rows, I want to make them look at by page, 100 entries per page, how to write a query, so that the rows from 100 to 200 would be shown?

Reported as a duplicate by participants 0xdb , AK ♦ , nick_n_a , Edward , Sergey Glazirin Jun 13 '18 at 5:42 .

A similar question was asked earlier and an answer has already been received. If the answers provided are not exhaustive, please ask a new question .

    1 answer 1

    SELECT * FROM `table` LIMIT 100,100

    SQL LIMIT statement

    Briefly analyze the request. If you read the syntax correctly, then logically it goes like this:

    Extract all columns from the table table, starting with the hundredth, in the amount of one hundred pieces.

    • Thank! Saw this, but realized ... - ArtGrek13
    • LIMIT is written before or after ORDER BY & - ArtGrek13
    • one
      @ ArtGrek13, yes. There will be something like SELECT * FROM table ORDER BY column ... LIMIT N,N - Vitali RS