case
CASE is a conditional expression.
coalesce
Returns the first non-NULL expression among the input parameters.
if
If expr1 evaluates to TRUE, returns expr2.
ifnull
If expr1 is NULL, returns expr2.
nullif
Returns NULL if expr1 is equal to expr2.
Version: 4.x