SQL CASE 语句

backtype = case a.backtype when '1' then '换货物' when '2' then '退钱' end,