Sorting of in subqueries in MySQL

To perform a query in the past few days, You need to query in a specified result set, for example:

Select * From table_name where doc_id in ('1dba ', 'c20a', '907b ')

 

The doc_id list in the in Clause obtains a list of doc_id Constants by calling an external interface, and searches the local database for the data that matches the list.

Record. Later, I found that the result set returned by MySQL is sorted in the order of receiving the database, but I want to sort it in the order of doc_id list,

After Google's knowledge, we can change it:

 

Select * From table_name where doc_id in ('1dba ', 'c20a', '907b ') order by find_in_set ('1dba', 'c20a ', '907b ')

The results are indeed achieved.

 

I'm amazed at the wide and profound nature of SQL. I need to study it carefully ......