Description
The FOUND_ROWS( ) function returns the multiple rows with no LIMIT clause.
This function has the form:
SELECT FOUND_ROWS()
Return Value
Returns multiple rows with no LIMIT clause.
Examples
The following example shows the basic use of this function:
mysql> SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name
-> WHERE id > 100 LIMIT 10;
mysql> SELECT FOUND_ROWS();