正常使用in
select order_id from study_order where order_id in('1','2','3','4') order by order_id;
select order_id from study_order where order_id in('1','2','3','4') order by order_id desc;
按照in语句的顺序返回结果
select order_id from study_order where order_id in ('1','2','3','4') order by instr(',2,1,4,3,',concat(',',order_id,','));