Mysql retrieves data between two rows

Question

New question: I want to get data between two lines, for example, line number 5 and line number 10. How can I do this? There is no identifier or integer column in the table, and I cannot modify the table.

Answer 1

You can use the limit

select * from `table` limit 4,5;