select * from order ORDER BY FIELD(status, ‘UNPAID’, ‘DELIVERED’, ‘PAID’, ‘WAIT_DELIVER’) desc/asc
mysql-按照指定字段排序
最新推荐文章于 2024-06-13 16:41:39 发布
select * from order ORDER BY FIELD(status, ‘UNPAID’, ‘DELIVERED’, ‘PAID’, ‘WAIT_DELIVER’) desc/asc