In limit query, what if do not have a particular column which is in serial order then how do we take records from 100 to 150.

Answer 1

Use ORDER BY.

SELECT * FROM mytable ORDER BY mycolumn LIMIT 99, 51;

(Sorry, I was 1 off.)

Answer 2

data from 151 to 170:
SELECT * FROM table name ORDER BY columnname LIMIT 150, 20;

(Sorry, I was 1 off.)

Answer 3

We need set unique I'd as primary and then order by Asc than limit to 100 to 150

Answer 4

so what if I want to take data from 151 to 170..
SELECT * FROM table name ORDER BY columnname LIMIT 151, 19;
Is it??

Answer 5

c'est une super app