Important
New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.
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: