FOUND_ROWS in mysql

FOUND_ROWS( )

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();