MySQL is ordered by the order in the in statement.

In SQL, we sometimes use in the query statement to query related data. For example:

1. Select * from goods where goods_id in ('20160301', '64', '20160301', '37', '20160301', '20160301', '20160301 ', '123', '123', '123', '123 ')
   

In the preceding query, the returned results are sorted from small to large in the order of good_id, that is, 222 ....

The expected return sequence is: '123', '64', '123', '37', '123', '123', '123', '123', '123 ', '123', '123', '123', '123'

Use the following statement:

1. Select * from goods where goods_id in ('20160301', '64', '20160301', '37', '20160301', '20160301', '20160301 ', '123', '123', '123', '123') Order
   By field (goods_id, '123', '64', '123', '37', '123', '123', '123', '123', '123 ', '123', '123', '123', '123 ')
   

 

The keyword field is followed by the field name goods_id to be sorted.