IFNULL

The IFNULL function returns the value of the first non-null expression.

Read syntax diagramSkip visual syntax diagram
>>-IFNULL--(--expression--,--expression--)---------------------><

The IFNULL function is identical to the COALESCE scalar function with two arguments. For more information, see COALESCE.

Example