December 17th, 1999, 12:09 PM
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.
December 17th, 1999, 01:21 PM
LIMIT 10,5 = Get 5 posts begin from 10.
select * from tb1 limit 10,5;
This will get row nr. 10 to 15
December 18th, 1999, 08:49 AM
IOW, you are requesting 10 rows beginning at 5. If you query only results in 12 matches then you'd get 7 rows.