为此,您可以使用ORDER BY FIELD。让我们首先创建一个表-mysql> create table DemoTable
-> (
-> Id int,
-> Name varchar(20)
-> );
使用插入命令在表中插入一些记录-mysql> insert into DemoTable values(101,'Chris');
mysql> insert into DemoTable values(201,'Mike');
mysql> insert into DemoTable values(110,'Adam');
mysql> insert into DemoTable values(250,'John');
使用select语句显示表中的所有记录-mysql> select *from DemoTable;
这将产生以下输出-+------+-------+
| Id | Name |
+------+-------+
| 101 | Chris |
| 201 | Mike |
| 110 | Adam |
| 250 | John |
+------+-------+
4 rows in set (0.00 sec)
这是使用按字段排序以及按id&miuns;排序的查询。mysql> select *from DemoTable
-> order by field(Name,'Mike') desc,Id desc;
这将产生以下输出-+------+-------+
| Id | Name |
+------+-------+
| 201 | Mike |
| 250 | John |
| 110 | Adam |
| 101 | Chris |
+------+-------+
4 rows in set (0.01 sec)