Conditional

IFNULL

MySQL

Mengembalikan expr1 jika tidak NULL, jika tidak mengembalikan expr2. Fungsi null-handling sederhana.

Tipe hasil: Same as expr1 or expr2Diperbarui: 7 Jan 2026

Syntax

SQL

IFNULL(expr1, expr2)

expr1anywajib

Ekspresi yang dicek apakah NULL

expr2anywajib

Nilai pengganti jika expr1 NULL

SQL

1 SELECT name, IFNULL(nickname, name) AS display_name
2 FROM users;

Gunakan name jika nickname NULL.

Hasil

(display name with fallback)

SQL

1 SELECT product,
2   price * IFNULL(quantity, 0) AS total
3 FROM orders;

Treat NULL quantity sebagai 0.

Hasil

(totals without NULL issues)

SQL

1 SELECT id, IFNULL(description, 'No description') AS desc
2 FROM products;

Teks default untuk deskripsi kosong.

Hasil

(products with default description)

NVL

Snowflake

IFNULL

BigQuery

COALESCE

DuckDB

COALESCE

PostgreSQL

1	SELECT name, IFNULL(nickname, name) AS display_name
2	FROM users;

1	SELECT product,
2	price * IFNULL(quantity, 0) AS total
3	FROM orders;

1	SELECT id, IFNULL(description, 'No description') AS desc
2	FROM products;