SELECT
*, CASE t.flag
WHEN '0' THEN
'待入库'
WHEN '1' THEN
'已完成'
WHEN '2' THEN
'进行中'
END as flagn
FROM
t_stock_in_orders t
mysql Case when 使用方法
最新推荐文章于 2024-02-25 09:00:00 发布
SELECT
*, CASE t.flag
WHEN '0' THEN
'待入库'
WHEN '1' THEN
'已完成'
WHEN '2' THEN
'进行中'
END as flagn
FROM
t_stock_in_orders t