coalesce
CREATE TABLE tbl as VALUES ('1', null), ('2', '2'), (null, '3'); SELECT COALESCE(column1, column2) as value FROM tbl; -- value '('1', '2', '3')'
function coalesce($1, ...) returns $1
if
SELECT IF(2 < 1, 'HIGHER') AS value; -- value 'NULL'
function if(boolean, $1) returns $1 function if(boolean, $1, $1) returns $1
nullif
SELECT nullif(1, 1) AS value; -- value 'NULL' SELECT nullif(2, 1) AS value; -- value '2'
function nullif($1, $1) returns $1
try
function try($1) returns $1