無商不雅

 case when 欄位=值1 then '文字1'  when 欄位=值2 then '文字2'  else null end

select * from tableName

order by case when field1 is null then 1 else 0 end, field1 asc

select Name, case Answer

when 1 then '喜歡'

when 2 then '不喜歡'

when 3 then '還OK'

END

FROM questionnaire;

select Name, case

when Answer=1 then '喜歡'

when Answer=2 then '不喜歡'

when Answer=3 then '還OK'

END

AS Answer

FROM questionnaire;

select  count( case when apptext is null then 'A' end ) from examination_app