COALESCE

Checks from left to right for the first non-NULL argument found for each entry parameter pair.

Syntax

COALESCE(<expression> [,...])

Parameter	Description	Supported input types
`<expression>`	The expression(s) to coalesce.	Any

Same as input type

The following example returns the first non-NULL value provided, which is the username esimpson:

SELECT COALESCE(NULL, 'esimpson', 'sabrina21') AS nicknames;

nicknames text
esimpson

Rows: 1Execution time: 6.68ms

⌘I