IF(expr1,expr2,expr3) : IF « Control Flow Functions « MySQL Tutorial

1. MySQL Tutorial
2. Control Flow Functions
3. IF

Syntax:

IF(condition,true_value,false_value)

If expr1 is TRUE (expr1 <> 0 and expr1 <> NULL) then IF() returns expr2; otherwise it returns expr3.

expr1 is evaluated as an integer value.

mysql>
mysql>
mysql> SELECT IF(1>2,2,3);
+-------------+
| IF(1>2,2,3) |
+-------------+
|           3 |
+-------------+
1 row in set (0.00 sec)

mysql>
mysql> SELECT IF(1<2,'yes','no');
+--------------------+
| IF(1<2,'yes','no') |
+--------------------+
| yes                |
+--------------------+
1 row in set (0.00 sec)

mysql>
mysql>