稍显复杂sql语句的用法

select case order_state when ‘0’ then ‘已取消’ when ‘10’ then ‘已下单’ when ‘20’ then if(payment_code = ‘offline’,’货到付款’,’已付款’) when ‘30’ then ‘已发货’ when ‘40’ then ‘已完成’ end from shopnc_order;

文章目录

原文链接: http://www.jiliuke.com/2015/08/11/e7-a8-8d-e6-98-be-e5-a4-8d-e6-9d-82sql-e8-af-ad-e5-8f-a5-e7-9a-84-e7-94-a8-e6-b3-95/

版权声明: 转载请注明出处.