mysql case when的使用

SELECT (CASE payType WHEN 1 THEN '微信' WHEN 2 THEN '支付宝' ELSE '余额' END) as type, count(payType) FROM order_info WHERE payJe > 0 AND payTime IS NOT NULL AND STATUS = 2 AND UNIX_TIMESTAMP(createtime) < 1487692800 AND UNIX_TIMESTAMP(createtime) > 1487692800 - 24 * 3600 group by type http://outofmemory.cn/code-snippet/1149/MySQL-if-case-statement-usage-summary