Re: how to find the number of rows in a select statement in a stored procedure

[Roland Bouman]

Yes, the docs do indicate that. But, its not a real problem, is it? I mean, you just wanted to test if it returns zero rows.

I mean this: after you execute the query, FOUND_ROWS() is either less than the LIMIT, in wich case it yielded FOUND_ROWS() rows, or FOUND_ROWS() is more then (or equal to) LIMIT, in wich case it yielded LIMIT rows.



Edited 1 time(s). Last edit at 10/12/2005 01:13AM by Roland Bouman.