IF(expr1,expr2,expr3)

Jika expr1 BENAR (expr1 0 dan expr1 BUKAN NULL), IF() mengembalikan expr2. Jika tidak, ia akan mengembalikan expr3.

Syntax

MYSQL Copy

SELECT IF(1>2,2,3);
3
SELECT IF(1<2,'yes','no');
'yes'
SELECT IF(STRCMP('test','test1'),'no','yes');
'no'

Contoh

Example

There is also an IF statement, which differs from the IF() function described here. See Section 15.6.5.2, “IF Statement”.

MYSQL Copy

SELECT IF(1>2,2,3);
3
SELECT IF(1<2,'yes','no');
'yes'
SELECT IF(STRCMP('test','test1'),'no','yes');
'no'