Shulou(Shulou.com)05/31 Report--

I believe many inexperienced people don't know what to do about how to sort in a specific order in mysql. Therefore, this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Mysql queries IN and sorts them in a specific order

When performing data query operations, sometimes we sort them in a specific order

I suddenly saw a sort method on the Internet, which can be recorded for later use:

Ordinary in query

Select * from score where id in (3, 1, 5)

We can see that the data are found, but not in the order we need.

So how to query in order to find out the data in this order (3Jing 1jue 5)?

Sort in a specific order (field)

Select * from score where id in (3, 1, 5) order by field (id,3,1,5)

After reading the above, have you mastered the method of sorting in a particular order in mysql? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.