基本
PHP
if ($score >= 90) $str = 'A'; elseif ($score >= 70 && $score < 90) $str = 'B'; elseif ($score >= 60 && $score < 70) $str = 'C'; else{ $str = 'D'; }
SQL
CASE WHEN score >= 90 THEN 'A' WHEN score >= 90 THEN 'B' WHEN score >= 90 THEN 'C' ELSE 'D' END AS str
欄位值
Name | Answer |
---|---|
張一 | 1 |
王二 | 2 |
李三 | 3 |
SELECT Name, case Answer when 1 then '喜歡' when 2 then '不喜歡' when 3 then '一般' END FROM table; OR SELECT Name, case when Answer=1 then '喜歡' when Answer=2 then '不喜歡' when Answer=3 then '一般' END AS Answer FROM table;
沒有留言:
張貼留言