參考如下用例：

SELECT user_id, rights_code, num, remain_num,
  CASE rights_code
    WHEN '10010' THEN '全場成本價'
    WHEN '10020' THEN '100元優(yōu)惠券'
    WHEN '10030' THEN '5折部分品類券'
    WHEN '10040' THEN '包郵券'
    WHEN '10050' THEN '一元購'
    WHEN '10060' THEN '奢侈品5折購'
    WHEN '10070' THEN '話費充值券'
    WHEN '20010' THEN '大牌咖啡'
    WHEN '20020' THEN '影音娛樂'
    WHEN '20030' THEN '速食簡餐'
    WHEN '20040' THEN '蛋糕甜品'
    WHEN '20050' THEN '城市商超'
    WHEN '20060' THEN '車主服務'
    WHEN '20070' THEN '迪士尼門票'
    WHEN '30010' THEN '0元免費領'
    WHEN '30020' THEN '免費開卡禮'
    WHEN '40010' THEN '購物返5倍鋼镚'
    WHEN '50010' THEN '優(yōu)先退換貨'
  ELSE rights_code
  END as name
FROM member_hold_rights where user_id='15035172';

查詢結果如下：

WeWork Helper20190911115952.png