Aggregate

FOUND_ROWS

MySQL

Returns the total number of rows the preceding SELECT would have returned without a LIMIT clause (requires SQL_CALC_FOUND_ROWS).

Tipe hasil: BIGINTDiperbarui: 13 Jun 2026

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 record count without the LIMIT applied.

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 number of search results.

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;

Full pagination metadata in a single round trip.

Hasil

total: 150, total_pages: 15

Pertanyaan Umum tentang FOUND_ROWS

Apa itu fungsi FOUND_ROWS di MySQL?

Returns the total number of rows the preceding SELECT would have returned without a LIMIT clause (requires SQL_CALC_FOUND_ROWS). Di MySQL, fungsi FOUND_ROWS termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan FOUND_ROWS di MySQL?

Gunakan sintaks berikut: FOUND_ROWS(). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.

Apa nilai yang dikembalikan oleh fungsi FOUND_ROWS?

Fungsi FOUND_ROWS mengembalikan nilai bertipe BIGINT. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda - selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.

Ngulik Langsung

Sudah paham FOUND_ROWS? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

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;