跳到主要内容

IF

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

Syntax

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

Arguments

ArgumentsDescription
<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 |
+----------------------------------------------+