Conditional

COALESCE

MySQL

Mengembalikan nilai non-NULL pertama dari daftar argumen. Generalisasi dari IFNULL untuk multiple values.

Tipe hasil: Same as first non-NULLDiperbarui: 7 Jan 2026

Syntax

SQL

COALESCE(value1, value2, ...)

value1, value2, ...anywajib

Nilai-nilai yang dicek (minimal 1)

SQL

1 SELECT COALESCE(mobile, home, office, 'No phone') AS phone
2 FROM contacts;

Coba beberapa kolom untuk mendapat nomor telepon.

Hasil

(first available phone number)

SQL

1 SELECT 
2   COALESCE(user_setting, group_setting, default_setting) AS setting
3 FROM config;

Cascade setting dengan prioritas.

Hasil

(cascading settings)

SQL

1 SELECT customer_id,
2   COALESCE(SUM(amount), 0) AS total
3 FROM orders
4 GROUP BY customer_id;

Return 0 jika tidak ada transaksi.

Hasil

(totals with zero default)

1	SELECT COALESCE(mobile, home, office, 'No phone') AS phone
2	FROM contacts;

1	SELECT
2	COALESCE(user_setting, group_setting, default_setting) AS setting
3	FROM config;