Premium
Log in
MySQL Function Reference
COALESCE
Returns the first non-null element of the list
MySQL 8.1
COALESCE(val1[, val2, ...., val_n])Examples
MySQL 8.1
SELECT COALESCE(NULL, NULL, 1, 2);COALESCE(val1[, val2, ...., val_n])SELECT COALESCE(NULL, NULL, 1, 2);