How to get from 11th to 20th lines?

Question

MySQL

I make a selection, but not all lines need to be displayed, but only from the 11th to the 20th lines. MySQL database.

Answer 1

SELECT * FROM table LIMIT 10,10;

Answer 2

if by id, then you can do this:
SELECT * FROM table WHERE id BETWEEN 11 and 20

Answer 3

It’s easier for you to cut it off on the output side, you got an array, for example, in php and parse it foreach

$i=0;
foreach($array as $item){

  if(10<$i || $i>19)
    continue;
echo $item['ваше_значение'];
  $i++;
}

Or maybe so
SELECT * FROM table LIMIT 11, 10