mysql CASE 语法

点击打开链接

CASE case_value

    WHEN when_value THEN statement_list
    [WHEN when_value THEN statement_list] ...
    [ELSE statement_list]
END CASE
或者


CASE
    WHEN search_condition THEN statement_list
    [WHEN search_condition THEN statement_list] ...
    [ELSE statement_list]

END CASE

demo 

SELECT
  CASE
    WHEN score = 10
    THEN '10'
    WHEN score = 23.87
    THEN '23.87'
    ELSE 'not 10 and 23.87'
  END
FROM score_test