mysql统计报表,状态值对应中文描述

SELECT sale_status,
CASE sale_status
WHEN 1
THEN  '未开发 '
WHEN 2
THEN  '线下推广意向 '
WHEN 3
THEN  '线上体验意向'
WHEN 4
THEN  '免费体验'
WHEN 5
THEN  '意向跳单'
WHEN 6
THEN  '免费终止'
WHEN 7
THEN  '付费'
WHEN 8
THEN  '付费终止'
WHEN 9
THEN  '被合并'
END AS  '销售状态'
FROM mw_user