Mysql 状态字段转中文描述 case then

来源:互联网 发布:淘宝店铺悬浮导航图片 编辑:程序博客网 时间:2024/06/01 09:55
 select order_sn,(case when (order_state = 0 ) then '已取消' when (order_state = 10 ) then '待发货' else order_state end) as 'order_state' from shop_order
0 0
原创粉丝点击