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)
bitscn.com