IS NOT NULL

Test whether a value is not NULL. IS NOT NULL returns 1 for any non-NULL value and 0 for NULL.

Syntax

IS NOT NULL

Description

Tests whether a value is not NULL. See also NULL Values in MariaDB.

Examples

SELECT 1 IS NOT NULL, 0 IS NOT NULL, NULL IS NOT NULL;
+---------------+---------------+------------------+
| 1 IS NOT NULL | 0 IS NOT NULL | NULL IS NOT NULL |
+---------------+---------------+------------------+
|             1 |             1 |                0 |
+---------------+---------------+------------------+

See also

• NULL values

• IS NULL operator

• COALESCE function

• IFNULL function

• NULLIF function

• CONNECT data types

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