mysql的查询sql中使用case的例子

SELECT AC.ACCOUNT_CODE, 
CASE 
     WHEN AC.ACCOUNT_TYPE = 1 THEN 'ASSETS'
     WHEN AC.ACCOUNT_TYPE = 2 THEN 'LIABILITIES'
     WHEN AC.ACCOUNT_TYPE = 4 THEN 'EQUITY'
     ELSE 'GAIN/LOSS' 
END ACCOUNT_TYPE,
IF(AC.CODE_TYPE = 0,'HEADER','DETAIL') AS CODE_TYPE,  
IF(AC2.NAME IS NULL, 'NONE', AC2.NAME) PARENT_ID_NAME, AC.`NAME`, AC.OTHER_NAME  
FROM T_FIN_ACCOUNTING_CODE AC   
LEFT JOIN T_FIN_ACCOUNTING_CODE AC2 ON AC2.ACCOUNT_ID = AC.PARENT_ID   
ORDER BY AC.ACCOUNT_CODE, AC.`NAME` ;