Mysql sorts the output result with the specified ID number

Mysql sorts the output result with the specified ID number

SELECT * FROM 'cms _ hit' WHERE aid in (55,173,177,174,175,176)

Generally, the specified ID of the SQL output needs to be sorted, and the output of the above results has certain uncertainty. According to requirements

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

.

Sometimes, the results are not only in reverse order, but also in reverse order. At first, I thought it was the rule of finding the ID, but I didn't understand it. I did not make it. I came back and checked the information. It was actually very simple.

SELECT *, instr (', 5,173,176,174,175,177,', concat (',', aid, ',') as c FROM 'cms _ hit' WHERE aid in, 55,173,177,174,175,176) order by c asc

These two functions are also common MYSQL functions.

Instr string 2, and position in string 1.

Concat connection string.