MySQL Control Flow Functions and Expressions

Name	Text
CASE	return the corresponding result in `THEN` branch if the condition in the `WHEN`
MySQL IF( ) Function
IFNULL
NULLIF