mysql的case when可以写在列里面，也可以写在where条件里
SELECT
mi.*, mo.OrderStatus,
(
CASE mi.Way
WHEN 20 THEN
mo.OrderStatus
ELSE
mi.`Status`
END) as customStatus
FROM
Mice_Inspection mi
LEFT JOIN
mice_order mo
on
mi.OrderId = mo.Id
WHERE
mi.isDeleted = 0
AND mi.EventId = 628872239
AND mi.CreateUserId = 1138
-- AND customStatus = 103
ORDER BY
mi.id DESC
LIMIT 0,20;
