IFNULL function [Miscellaneous]

If the first expression is the NULL value, then the value of the second expression is returned. If the first expression is not NULL, the value of the third expression is returned. If the first expression is not NULL and there is no third expression, NULL is returned.

Syntax

IFNULL( expression-1, expression-2 [ , expression-3 ] )

Parameters

expression-1 The expression to be evaluated. Its value determines whether expression-2 or expression-3 is returned.
expression-2 The return value if expression-1 is NULL.
expression-3 The return value if expression-1 is not NULL.

Returns

Standards and compatibility

Example

Discuss this page in DocCommentXchange.