RTFM - It is online, it has an index, and it is searchable:
http://dev.mysql.com/doc/mysql/en/select.html (hint: look for the phrase
"how many rows" on this page)
If you looked in the index for "rows", you would find the function
ROW_COUNT() (which is close but not exactly what you wanted). However, by
clicking on the link next to that function, you wind up at another page
that also has the answer you seek.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
pow <powster@stripped> wrote on 09/07/2005 06:15:12 AM:
> Hi everyone, Im executing the following query:
>
> SELECT *
> FROM
> table1
> WHERE
> table1.field1 = 'A' AND table1.field2 = 'B'
> LIMIT 0,10
>
> I also need to get the total record count for the above query, but
> without the limit clause (limit is for pagination purposes)
> Is there any way to extract this total record count without the need to
> do another query?
>
> Right now I am using another query to get the total record count:
>
> SELECT COUNT(*)
> FROM
> table1
> WHERE
> table1.field1 = 'A' AND table1.field2 = 'B'
>
>
> In reality, my tables are very large, and involve joins, so executing
> the query TWICE is taking its toll on the server.
> Thanks!
> Pow
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
