14.6.5.1 CASE Syntax ~~~ CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ... [ELSE statement_list] END CASE ~~~ Or: ~~~ CASE WHEN search_condition THEN statement_list [WHEN search_condition THEN statement_list] ... [ELSE statement_list] END CASE ~~~ 用例 ~~~ SELECT EmployeeID, NAME, Address, CASE WHEN DepartmentID = '1' THEN '財務部' WHEN DepartmentID = '2' THEN '人力資源部' WHEN DepartmentID = '3' THEN '經理辦公室' WHEN DepartmentID = '4' THEN '研發部' WHEN DepartmentID = '5' THEN '市場部' END CASE AS DepartmentID FROM Employees ~~~ * * * * * https://dev.mysql.com/doc/refman/5.7/en/case.html