Interesting comment in the manual, though, where someone says they tried both methods and found the multiple statements to be faster than SQL_CALC_FOUND_ROWS.
--jeff ----- Original Message ----- From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Fletcher Sandbeck" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 3:04 PM Subject: RE: Getting Found Count When Using Limit > * Fletcher Sandbeck > > Actually, easy thing to do through the APIs or most third-party > > languages that let you access MySQL. I'm looking for a way to > > do it using raw MySQL statements. > > > > I think I found my answer in the list archives. It's not > > possible without using multiple SQL statements. > > There is a way to do it if you are using version 4... from the manual: > > "SQL_CALC_FOUND_ROWS tells MySQL to calculate how many rows there would be > in the result, disregarding any LIMIT clause. The number of rows can be > obtained with SELECT FOUND_ROWS()." > > <URL: http://www.mysql.com/doc/S/E/SELECT.html > > > -- > Roger > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
