Conditional

IF

MySQL

Fungsi if-then-else sederhana. Mengembalikan nilai berdasarkan kondisi boolean.

Tipe hasil: VariesDiperbarui: 7 Jan 2026

Syntax

SQL

IF(condition, true_value, false_value)

conditionbooleanwajib

Kondisi yang dievaluasi

true_valueanywajib

Nilai jika kondisi true

false_valueanywajib

Nilai jika kondisi false atau NULL

SQL

1 SELECT name, age,
2   IF(age >= 18, 'Adult', 'Minor') AS category
3 FROM users;

Kategorisasi berdasarkan umur.

Hasil

(users categorized by age)

SQL

1 SELECT product,
2   IF(is_active, 'Yes', 'No') AS active_status
3 FROM products;

Konversi boolean ke teks.

Hasil

(products with Yes/No status)

SQL

1 SELECT score,
2   IF(score >= 90, 'A',
3     IF(score >= 80, 'B',
4       IF(score >= 70, 'C', 'F')
5     )
6   ) AS grade
7 FROM students;

IF bersarang untuk multiple kondisi.

Hasil

(grades using nested IF)

CASE

PostgreSQL

IFF

Snowflake

BigQuery

DuckDB

1	SELECT name, age,
2	IF(age >= 18, 'Adult', 'Minor') AS category
3	FROM users;

1	SELECT product,
2	IF(is_active, 'Yes', 'No') AS active_status
3	FROM products;