举例1
UPDATE biz_table
SET biz_tags = CASE biz_id
WHEN 2408466 THEN '["不限"]'
WHEN 2408533 THEN '["不限"]'
END
WHERE biz_id IN (2408466,2408468)
举例 2
SELECT batch, count(*) as "领取量" FROM (
select CASE batch_id
WHEN 13 THEN "百度"
WHEN 14 THEN "苏宁"
WHEN 16 THEN "赚动"
WHEN 17 THEN "亚朵"
WHEN 18 THEN "京东"
END as batch FROM `coupon` WHERE `batch_id` IN (13,14,16,17,18) and `open_id` IS NOT NULL ) b GROUP BY batch
