Aggregate

FOUND_ROWS

MySQL

Mengembalikan jumlah total baris yang akan dikembalikan SELECT sebelumnya tanpa LIMIT (memerlukan SQL_CALC_FOUND_ROWS).

Tipe hasil: BIGINT

Syntax

SQL

FOUND_ROWS()

Parameter

Fungsi ini tidak memerlukan parameter.

Contoh Penggunaan

Pagination Total

SQL

1 SELECT SQL_CALC_FOUND_ROWS * FROM products LIMIT 10;
2 SELECT FOUND_ROWS() AS total_products;

Total records tanpa LIMIT.

Hasil

total_products: 1500

Search with Count

SQL

1 SELECT SQL_CALC_FOUND_ROWS * FROM users 
2 WHERE name LIKE '%john%' LIMIT 20;
3 SELECT FOUND_ROWS() AS total_matches;

Total hasil pencarian.

Hasil

total_matches: 85

Pagination Info

SQL

1 SELECT SQL_CALC_FOUND_ROWS id, title FROM posts
2 ORDER BY created_at DESC LIMIT 10 OFFSET 0;
3 SELECT FOUND_ROWS() AS total,
4        CEIL(FOUND_ROWS() / 10) AS total_pages;

Info pagination lengkap.

Hasil

total: 150, total_pages: 15

Kembali ke MySQL Functions

1	SELECT SQL_CALC_FOUND_ROWS * FROM products LIMIT 10;
2	SELECT FOUND_ROWS() AS total_products;

1	SELECT SQL_CALC_FOUND_ROWS * FROM users
2	WHERE name LIKE '%john%' LIMIT 20;
3	SELECT FOUND_ROWS() AS total_matches;

1	SELECT SQL_CALC_FOUND_ROWS id, title FROM posts
2	ORDER BY created_at DESC LIMIT 10 OFFSET 0;
3	SELECT FOUND_ROWS() AS total,
4	CEIL(FOUND_ROWS() / 10) AS total_pages;