IF

If expr1 is TRUE, IF() returns expr2. Otherwise, it returns expr3.

Syntax

IF( <expr1>, <expr2>, <expr3>)

Arguments

Arguments	Description
<expr1>	The condition for evaluation that can be true or false.
<expr2>	The expression to return if condition is met.
<expr3>	The expression to return if condition is not met.

Return Type

The return type is determined by expr2 and expr3, they must have the lowest common type.

Examples

SELECT if(number=0, true, false) FROM numbers(1);
+-------------------------------+
| if((number = 0), true, false) |
+-------------------------------+
|                             1 |
+-------------------------------+

SELECT if(number > 5, number*5, number+5 ) FROM numbers(10);
+----------------------------------------------+
| if((number > 5), (number * 5), (number + 5)) |
+----------------------------------------------+
|                                            5 |
|                                            6 |
|                                            7 |
|                                            8 |
|                                            9 |
|                                           10 |
|                                           30 |
|                                           35 |
|                                           40 |
|                                           45 |
+----------------------------------------------+