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

This article shows you how to use the field () sorting function in the MySQL database, the content is concise and easy to understand, it can definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Field () function

The mode of use is as follows

Among them, order by (str,str1,str2,str3,str4... ), str is compared with str1,str2,str3,str4, where str refers to the field name

The field str returns the queried result set in the order of the string str1,str2,str3,str4. If the str field value in the table does not exist in the record in str1,str2,str3,str4, it is returned at the top of the result set.

Now that we know how to use it, let's implement the above requirements

First of all, let's sort in positive order.

Or sort by 'seiki','iris'', and the result is as follows

Now let's sort 'seiki','iris' in reverse order.

The above is how to use the field () sorting function in the MySQL database. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.