Skip to main content

NULLIF

Returns NULL if the arguments are equal, otherwise the first argument.

Syntax

NULLIF (val1, val2)

Arguments

  • Any SQL objects

Return Type

The return value has the same type as the first argument, or NULL.

Examples

SELECT NULLIF(1,2);
****
+-------------+
| NULLIF(1,2) |
+-------------+
|           1 |
+-------------+
SELECT NULLIF(2,2);
****
+-------------+
| NULLIF(2,2) |
+-------------+
|        NULL |
+-------------+
SELECT NULLIF(NULL, NULL);
****
+--------------------+
| NULLIF(NULL, NULL) |
+--------------------+
| NULL               |
+--------------------+
SELECT NULL = NULL;
****
+-------------+
| NULL = NULL |
+-------------+
|        NULL |
+-------------+