Re: Number of rows returned

[Philip Mak]

On Sat, Jun 01, 2002 at 04:15:47PM -0400, Philip Mak wrote:
> Given that I have that LIMIT constraint, is there a way to determine
> how many rows would have been returned if I did NOT have the LIMIT
> constraint?

Never mind, I found the answer. (It only works in MySQL 4.0, but
that's fine for my project.)

mysql> SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name
       WHERE id > 100 LIMIT 10;
mysql> SELECT FOUND_ROWS();