sql查询多对一转义字段值
查询结果要求转移
表名 order
字段名 order_status
转义结果 1或2 时 输出 0
其余逻辑相相同
AS 是 手写转移字段名 字段多用resultMap
SELECT order_status
CASE
WHEN order_status IN(1,2) THEN 0
WHEN order_status IN(21,22,23,24,3,5,6,7,9) THEN 10
WHEN order_status = 4 THEN 11
WHEN order_status = 8 THEN 3
END AS orderStatus
FROM order
WHERE order_no = 'xxxxxxxxx'