MySQL sorts output results with specified ID number

General SQL output specifies that the ID needs to be sorted, and the result output above has some uncertainty. Requirements by

55,6,5,173,176,174,175,177

Output results in the sequential order.

The result is sometimes not just reverse order, the reverse can complete the demand. At first I thought it was to find the law of ID, not understand the meaning. Did not do, came back to check the information, in fact, it is very simple.

SELECT *,instr (', 55,6,5,173,176,174,175,177, ', concat (', ', ' Aid, ', ')) as C from ' Cms_hit ' WHERE aid in ( 5,6,55,173,177,174,175,176) Order BY c ASC

The 2 functions used are also common MySQL functions.

InStr the string 2, and then the position in string 1.

Concat the connection string.

MySQL sorts output results with specified ID number