Skip to main content

NULLIF

The NULLIF() function compares two expressions and returns NULL if they are equal. Otherwise, the first expression is returned.

NULLIF() is available under planner_v2.

Syntax​

IF( <expr1>, <expr2>)

Arguments​

ArgumentsDescription
<expr1>Any general expression of any data type.
<expr2>Any general expression that evaluates to the same data type as \<expr1>.

Return Type​

The data type of the returned value is the data type of \<expr1>.

Examples​

SET enable_planner_v2 = 1;

SELECT a, b, NULLIF(a, b) FROM t;
+------+------+--------------+
| a    | b    | NULLIF(a, b) |
+------+------+--------------+
|    0 |    0 |         NULL |
|    0 |    1 |            0 |
|    0 | NULL |            0 |
|    1 |    0 |            1 |
|    1 |    1 |         NULL |
|    1 | NULL |            1 |
| NULL |    0 |         NULL |
| NULL |    1 |         NULL |
| NULL | NULL |         NULL |
+------+------+--------------+