如何使用MySQL ORDER BY按值进行排序？

为此，请使用ORDER BY子句。让我们首先创建一个表−

mysql> create table DemoTable
(
  StudentId int
);
Query OK, 0 rows affected (0.59 sec)

现在您可以使用插入命令在表中插入一些记录−

mysql> insert into DemoTable values(100);
Query OK, 1 row affected (0.14 sec)
mysql> insert into DemoTable values(60);
Query OK, 1 row affected (0.15 sec)
mysql> insert into DemoTable values(70);
Query OK, 1 row affected (0.13 sec)
mysql> insert into DemoTable values(45);
Query OK, 1 row affected (0.24 sec)
mysql> insert into DemoTable values(55);
Query OK, 1 row affected (0.13 sec)
mysql> insert into DemoTable values(78);
Query OK, 1 row affected (0.14 sec)

使用select语句从表中显示所有记录−

mysql> select *from DemoTable;

阅读更多：MySQL 教程

输出

+-----------+
| StudentId |
+-----------+
| 100       |
| 60        |
| 70        |
| 45        |
| 55        |
| 78        |
+-----------+
6 rows in set (0.00 sec)

以下是使用ORDER BY按值排序的查询。这里，首先我们显示70，因为我们已经使用ORDER BY设置了其顺序。其余的id按升序显示-

mysql> select *from DemoTable order by StudentId=70 desc,StudentId asc;

输出

+-----------+
| StudentId |
+-----------+
| 70        |
| 45        |
| 55        |
| 60        |
| 78        |
| 100       |
+-----------+
6 rows in set (0.00 sec)