MySQL Query Bug?

Question

I do that query that should return me 5 query but I get 10...

SELECT *
FROM article ar, account ac
WHERE ar.approved = '1'
AND ar.author = ac.id
ORDER BY ar.id DESC
LIMIT 5 , 10

Showing rows 0 - 9 (10 total, Query took 0.0028 sec)

What am I doing wrong? It was working fine before...

You are asking for 10 rows. If you want 5 rows, use LIMIT 5, 5,. — Gordon Linoff
– Gordon Linoff, Commented Dec 1, 2014 at 4:07

MarcinJuraszek · Accepted Answer · 2014-12-01 04:07:12Z

2

In mySQL LIMIT X, Y means

that's why you're getting 10 rows back.

If you only want 5 rows back and you need 5 first rows to be skipped, you should use LIMIT 5, 5.

answered Dec 1, 2014 at 4:07

MarcinJuraszek

126k15 gold badges200 silver badges267 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks that was the issue. I tough it was working another way. I will accept it as answer in 10 min.

G3V · Accepted Answer · 2014-12-01 04:29:42Z

0

As you need only 5 rows and you need to skip the first 5 rows use: LIMIT(5,5)

answered Dec 1, 2014 at 4:29

G3V

1111 silver badge9 bronze badges

Ataboy Josef · Accepted Answer · 2014-12-01 04:44:56Z

0

Try this:

SELECT *
FROM article ar, account ac
WHERE ar.approved = '1'
AND ar.author = ac.id
LIMIT 5, 10
ORDER BY ar.id DESC

Here is the grammer:

The offset(5) specifies the offset of the first row to return. The offset of the first row is 0, not 1.
The count(10) specifies maximum number of rows to return.

answered Dec 1, 2014 at 4:44

Ataboy Josef

2,1093 gold badges24 silver badges28 bronze badges