MySQL Control Flow Functions and Expressions

return the corresponding result in THEN branch if the condition in the WHEN

This control flow function that lets you return different values based on a condition inside your SQL query.

MySQL control flow functions that accepts two arguments and returns the first argument if it is not NULL

The NULLIF function is one of the control flow functions that accepts 2 arguments.