[RESOLVED] Ranged limit doesn't work

[2CODE]

I know that I can use limit to get x results starting from x row.

So here's my query

SELECT id, title, date FROM pages WHERE show = '1' LIMIT 23, 100

I want to get 100 result from pages table starting from id number 23

However it return zero results 😕

[laserlight]

2CODE wrote:

I want to get 100 result from pages table starting from id number 23

Ah. In that case, you're really looking for something like:

SELECT id, title, date FROM pages WHERE show = '1' AND id >= 23 ORDER BY id LIMIT 100