COALESCE(value,...)

MySQL 8.4

Returns the first non-NULL value in the list, or NULL if there are no non-NULL values.

Syntax

MYSQL

SELECT COALESCE(NULL,1);
1
SELECT COALESCE(NULL,NULL,NULL);
NULL

Example

The return type of COALESCE() is the aggregated type of the argument types.

MYSQL

SELECT COALESCE(NULL,1);
1
SELECT COALESCE(NULL,NULL,NULL);
NULL