IS NOT 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}