Function Reference
IF
Returns the value passed in the 2nd or 3rd argument, depending on whether the conditional expression is true
MySQL 8.1
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 8.1
SELECT IF(10 > 20, "TRUE", "FALSE");