Example of using CASE WHEN in MySQL sorting

Preface

In a previous project, the CASE WHEN sorting function in SQL was used. Now write a blog memo~

Database version: MySQL 5.6.42

condition:

A field represents the state of the data and takes a non-negative integer value, where 0 means no state.

need:

Sort by this field in ascending order, and put the data with a value of 0 at the end.

First, let's look at the structure of the table:

The normal query result in ascending order is as follows:

To put "小赤" at the end, you can write:

You can also do this:

You can also use CASE WHEN to change the sorting basis without affecting the query results:

Summarize

The above is the full content of this article. I hope that the content of this article will have certain reference learning value for your study or work. If you have any questions, you can leave a message to communicate. Thank you for your support for 123WORDPRESS.COM.