Make SQL statements unordered and return results in the order of in statements

Mysql: SELECT * FROMEVENTWHEREeventIdIN (443,419,431,440,420,414,509) ORDERBYINSTR (, 443,419,431,440,420,414,509, CONCAT (, eventId,) oracle: SELECTNAMEFROMorderWHEREoderidIN (111,222,333,444,555,666) ORDERBYINSTR ()

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 ('100, 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 ('20170901', orderid)

Original article address: Let the SQL statements not sort and return results in the order of in statements. Thanks to the original author for sharing.