Evaluates a condition and returns different results based on whether the condition is true or false. The IF function is a simplified alternative to the CASE expression for handling conditional logic.
Syntax
IF(<condition>, <then>, <else>)
Parameters
| Parameter | Description | Supported input types |
|---|
<condition> | Condition that the function evaluates. | BOOLEAN |
<then> | Value returned when <condition> evaluates to true. | Any |
<else> | Value returned when <condition> evaluates to false or NULL. Must match the data type of <then>. | Any |
Return type
The IF function returns the same data type as the <then> and <else> parameters.
Example
The following example classifies each level in the levels table as 'Hard' when its maxpoints score threshold is 100 or above, and 'Easy' otherwise:
SELECT level, name, IF(maxpoints >= 100, 'Hard', 'Easy') AS difficulty
FROM levels
ORDER BY level;
| level int null | name text null | difficulty text |
|---|
| 1 | Thunderbolt Circuit | Easy |
| 2 | Velocity Vale | Easy |
| 3 | Raceway Ridge | Easy |
| 4 | Nitro Narrows | Hard |
| 5 | Thunder Road | Hard |
| 6 | Burnout Boulevard | Easy |
| 7 | Speed Street | Easy |
| 8 | Racing Ravine | Hard |
| 9 | Drift District | Hard |
| 10 | Acceleration Alley | Hard |
Rows: 10Execution time: 6.00ms
