From: "Victor Spång Arthursson" <[EMAIL PROTECTED]> > Is there a simple way to get the total number of rows a result _should_ > have had if no where-clause where present? Without doing a second > query?
Example from http://www.mysql.com/doc/en/Information_functions.html : mysql> SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name WHERE id > 100 LIMIT 10; mysql> SELECT FOUND_ROWS(); Available since 4.0.0.; in versions prior to 4.1.0. this didn't work with LIMIT 0. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]