SQL · System and metadata

ifnull()

Returns the fallback when the first value is NULL. SQLite.

sqlRunnable example sql course

Syntax

ifnull(value, fallback)

Example

Open in the lab

SELECT ifnull(NULL, 'fallback') AS value;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.