Mysql fetch data between two rows

Newbie question: I want to get data between two rows, say, row number 5 and row number 10. How can I do that? There is no id or any integer column in the 开发者_开发问答table and I cannot modify the table.

You can use limit

select * from `table` limit 4,5;