IS_NOT_NULL

is_not_null(expr)

Description

The IS_NOT_NULL function is used to check whether a given expression (expr) is not null. If the expression is not null, the function returns true; otherwise, it returns false. This function works the same as the IS NOT NULL condition in SQL statements.

Parameter Description

• expr: An expression of any type, used to check whether its value is null.

Return Result

Returns a boolean value, true if expr is not null, otherwise false.

Example

1. Check if a number is not null

SELECT is_not_null(1); -- Returns true SELECT is_not_null(NULL); -- Returns false

2. Check if the string is not null

SELECT is_not_null('hello'); -- Returns true SELECT is_not_null(''); -- Returns true

3. Check if the date is not null

SELECT is_not_null('2022-01-01'); -- Returns true SELECT is_not_null(NULL); -- Returns false

4. Use IS_NOT_NULL in queries to filter non-null records

SELECT id, name, age FROM users WHERE is_not_null(age); -- Only return records where the age field is not null