I have a table with thousands of rows and it keeps growing. I want a query so I can easily display a chosen set of rows e.g:

• rows 1-50
• rows 51-100
• etc.

How can I write it?

CodePudding user response：

In this case you should use

SELECT column_name(s) FROM table_name WHERE condition LIMIT number;