SQL Function Reference

Returns the value passed in the 2nd or 3rd argument, depending on whether the conditional expression is true

MySQL

IF(condition, value_if_true, value_if_false)

condition

Conditional expression

value_if_true

The value returned when the conditional expression is true

value_if_false

The value returned if the conditional expression is false

Examples

MySQL

SELECT IF(10 > 20, "TRUE", "FALSE");