How to count all rows when using SELECT with LIMIT in MySQL query?
Posted
by SaltLake
on Stack Overflow
See other posts from Stack Overflow
or by SaltLake
Published on 2010-03-13T20:00:21Z
Indexed on
2010/03/13
20:05 UTC
Read the original article
Hit count: 177
mysql
|mysql-query
I've got a mysql query like this:
SELECT A.ID, A.NAME, B.ID, B.NAME
FROM table1 A
JOIN table2 B ON ( A.ID = B.TABLE1_ID )
WHERE
cond1, cond2, ..., condN
LIMIT 10
I've got many where clauses in query. How to improve this query to get also full row count? I don't want to use one more request without LIMIT.
© Stack Overflow or respective owner