mysql 搜索按照in中顺序排序

发表于 2015-08-11 更新于 2022-04-15 分类于 MYSQL

select * from shopnc_order where order_id in (1225,1228,1231,1233) order by FIND_IN_SET(order_id,’1228,1225,1231,1233’);