Oracle:
select name from order where order_id in('111','222','333','444','555','666')order by instr('111,222,333,444,555,666',order_id);
select name from order where order_iOracle:
select name from order where order_id in('111','222','333','444','555','666')order by instr('111,222,333,444,555,666',order_id);
select name from order where order_i