ISNULL

Test whether an expression is NULL. ISNULL() returns 1 if the expression is NULL, and 0 otherwise.

Syntax

ISNULL(expr)

Description

If expr is NULL, ISNULL() returns 1, otherwise it returns 0.

See also NULL Values in MariaDB.

Examples

SELECT ISNULL(1+1);
+-------------+
| ISNULL(1+1) |
+-------------+
|           0 |
+-------------+

SELECT ISNULL(1/0);
+-------------+
| ISNULL(1/0) |
+-------------+
|           1 |
+-------------+

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}