SQL CASE 的用法

CASE WHEN
欄位= ?
THEN '變成什麼值'
Else '' <--when沒找到的話就空白
End 結尾
as <--搜尋到的資料另建一個匿名欄位
SELECT Order_id, Conten_H1, Conten_H2, Conten_H3, Conten_View, CASE WHEN Conten_View = 1 THEN 'V' ELSE '' END AS Conten_View_show FROM Jsl_Index_Conten ORDER BY Order_id DESC