例:
SELECT CASE STATUS
WHEN '0' THEN '男'WHEN '1' THEN '女'
ELSE '非' END
FROM table
--------------------------------------------------------------------------
SELECT CASE
WHEN STATUS = '0' THEN '男'
WHEN STATUS = '1' THEN '女'
ELSE '非' END
FROM table