Important

The SingleStore 10 release candidate (RC) gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 10.

FOUND_ROWS

Syntax

SQL

FOUND_ROWS()

Arguments

None

Return Type

int

Examples

SQL

SHOW TABLES;

+--------------+
| Tables_in_db |
+--------------+
| testdata     |
+--------------+

SQL

SELECT FOUND_ROWS();

+--------------+
| FOUND_ROWS() |
+--------------+
|            1 |
+--------------+

SQL

SELECT ID FROM neighborhoods LIMIT 2;

+------+
| id   |
+------+
|    1 |
|    3 |
+------+

SQL

SELECT FOUND_ROWS();

+--------------+
| FOUND_ROWS() |
+--------------+
|            2 |
+--------------+

SQL

SELECT * FROM testdata;

+----------+
| Results  |
+----------+
|        1 |
|        2 |
|        3 |
|        4 |
|        5 |
+----------+

SQL

SELECT FOUND_ROWS;

+--------------+
| FOUND_ROWS() |
+--------------+
|            5 |
+--------------+

SQL

DESC testdata;

+-------+---------+------+------+---------+-----------+
| Field  | Type       | Null | Key  | Default | Extra |
+-------+-------------+------+------+---------+-------+
| id     | int(10)    | NO   |      | NULL    |       |
+--------+------------+------+------+---------+-------+
| name   | varchar(64)| NO   |      | NULL    |       |
+--------+------------+------+------+---------+-------+
| amount | int(10)    | NO   |      | NULL    |       |
+-------+---------+------+------+---------+-----------+

SQL

SELECT FOUND_ROWS;

+--------------+
| FOUND_ROWS() |
+--------------+
|            1 |
+--------------+

Note

Please note, there can be an incorrect result given when running a query using LIMIT with an offset. See the following example:

SQL

CREATE TABLE t1 (
    a BIGINT PRIMARY KEY AUTO_INCREMENT,
    b INT
);

INSERT random integers into t1 so total row count is greater than LIMIT argument.

SELECT COUNT(*)
FROM t1
GROUP BY a
ORDER BY a
LIMIT 5,10;
+----------+
| COUNT(*) |
+----------+
|        1 |
|        1 |
|        1 |
|        1 |
|        1 |
|        1 |
|        1 |
|        1 |
|        1 |
|        1 |
+----------+
10 rows in set (0.03 sec)

SELECT FOUND_ROWS(); -- the result should be 10
+--------------+
| FOUND_ROWS() |
+--------------+
|           15 |
+--------------+
1 row in set (0.00 sec)