Important
The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.
In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.
NULLIF
On this page
The NULLIF() function 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: