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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] >
