# MySQL CASE / IF ```sql= CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 WHEN conditionN THEN resultN ELSE result END AS alias ``` 類似 ```sql= IF(condition, value_if_true, value_if_false) ``` ###### tags: `MySQL`