NULLIF
On this page
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 |
+-------------+Last modified: February 24, 2023