Dev Shed Forums

SELECT id, title, genre, price FROM Pictures WHERE title LIKE '% %' ORDER BY title LIMIT 5,10
As I understand it - with the following command I should get the result between 5 and 10 (5 posts) but I get 7 posts!?

Is this a bug or have I missunderstood the use of LIMIT?

When i Use the same query with LIMIT 0,5 I get 5 posts.

LIMIT 10,5 = Get 5 posts begin from 10.

example:
select * from tb1 limit 10,5;
This will get row nr. 10 to 15

IOW, you are requesting 10 rows beginning at 5. If you query only results in 12 matches then you'd get 7 rows.