mysql: select * from event where eventid in(443,419,431,440,420,414,509) order by instr(',443,419,431,440,420,414,509,',concat(',',eventid,',')) oracle: select name from order where oderid in (111,222,333,444,555,666) order by instr('111,2
mysql:
select * from event where eventid in(443,419,431,440,420,414,509) order by instr(',443,419,431,440,420,414,509,',concat(',',eventid,','))
oracle:
select name from order where oderid in (111,222,333,444,555,666) order by instr('111,222,333,444,555,666',orderid)
原文地址：让sql语句不排序,按照in语句的顺序返回结果, 感谢原作者分享。