Hello.
You want to check out the FOUND_ROWS() function: http://dev.mysql.com/doc/mysql/en/information-functions.html BTW, similar question was asked recently. pow <[EMAIL PROTECTED]> wrote: > 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 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
