Skip to main content

IS_NOT_NULL

Checks whether a value is not NULL.

Syntax

IS_NOT_NULL( <expr> )

Arguments

ArgumentsDescription
<expr>Any general expression which will be evaluated as the value.

Return Type

If x is not NULL, is_not_null() returns 1, otherwise it returns 0.

Examples

CREATE TABLE nullable_test (a INT NULL, b INT UNSIGNED NULL);

INSERT INTO nullable_test VALUES(1, NULL), (NULL, 2), (3, 3);

SELECT a FROM nullable_test WHERE is_not_null(a);
+------+
| a |
+------+
| 1 |
| 3 |
+------+