7 replies to this topic

[Monkuar]

Okay, no idea why LIMIT doesn't work on count. I only want to limit the first 2500 rows.....

SELECT COUNT(id) as reports FROM users WHERE id != 1 LIMIT 2500

still does not work, any idea?

[Manixat]

post your error message

Edited by Manixat, 29 December 2012 - 06:41 AM.

[trq]

You are kidding right? You want a count of how many records there are in your query but limit it to 2500 ?

That would be 2500.

[scootstah]

COUNT() only returns one row, so that's why you can't LIMIT it. You could do a normal SELECT query and then use PHP to count the result set.

[Christian F.]

Use a subquery, set the limit in that, and have the count be in the outer query.

Edited by Christian F., 29 December 2012 - 09:32 AM.

[trq]

Use a subquery, set the limit in that, and have the count be in the outer query.

This will return 2500. The point of my original reply was not that it couldn't be done. It is that it makes NO SENSE to do so. The number the op wants is 2500, why run a database query to get it?

[Barand]

It could be less than 2500

[trq]

Potentially. Though I get the impression it's not.

In that case though, I would use something like:

SELECT IF (COUNT(id) > 2500, 2500, COUNT(id)) AS total FROM tbl;