Mysqlin is sorted by query id _ MySQL

Mysqlin sorts bitsCN.com by query id

Mysql in is sorted by query id

When mysql in is queried, the returned results are sorted by themselves. if you want to sort the results by the ID of our query,
Order by field is used. the following example shows how to sort mysql in queries.

Example: www.bitsCN.com

SQL: select * from table where id IN (3, 6, 9, 1, 2, 5, 8, 7 );

After such a situation is obtained, the IDS are sorted by 1, 2, 3, 4, 5, 6, 7, 8, 9, but if we really want
What should I do with the order of the above? We can use order by field

SQL: select * from table where id IN (,) order by field (id );

The query result is sorted by the custom ID.

BitsCN.com