IS NOT NULL

Tests whether a value is not NULL.

Syntax

MYSQL Copy

SELECT 1 IS NOT NULL, 0 IS NOT NULL, NULL IS NOT NULL;
1, 1, 0

Examples

Example

MYSQL Copy

SELECT 1 IS NOT NULL, 0 IS NOT NULL, NULL IS NOT NULL;
1, 1, 0