sql查询结果根据表字段数据条件显示相应的内容.md

####原始sql###

SELECT sell_number AS 销售账号,STATUS AS 状态  FROM `sangelfine_duty_paragraph_maintain`

###修改的sql###

SELECT sell_number AS 销售账号,CASE WHEN STATUS =1 THEN '启用' WHEN STATUS = 0 THEN '禁用' ELSE '其他' END AS 状态
FROM `sangelfine_duty_paragraph_maintain`

结果是这样的