shopro商城，sql语句
查询已退款的水票订单，但是退款状态又显示未退款SELECT * FROM `fa_shopro_order` where apply_refund_status=0 and ext like '%refund_time%' and worker_status>0更新已退款的水票订单的退款状态为已退款updatefa_shopro_order setapply_refund_status=2where apply_refund_status=0 and e
admin
查询已退款的水票订单，但是退款状态又显示未退款
SELECT * FROM `fa_shopro_order` where apply_refund_status=0 and ext like '%refund_time%' and worker_status>0
更新已退款的水票订单的退款状态为已退款
update fa_shopro_order set apply_refund_status=2 where apply_refund_status=0 and ext like '%refund_time%' and worker_status>0
