要先在MySQL中按特定字段值排序,请使用ORDER BY FIELD()。让我们首先创建一个表-mysql>createtableDemoTable849(Colorvarchar(100));
使用插入命令在表中插入一些记录-mysql>insertintoDemoTable849values('RED');
mysql>insertintoDemoTable849values('ORANGE');
mysql>insertintoDemoTable849values('BLUE');
mysql>insertintoDemoTable849values('GREEN');
使用select语句显示表中的所有记录-mysql>select*fromDemoTable849;
这将产生以下输出-+--------+
|Color|
+--------+
|RED|
|ORANGE|
|BLUE|
|GREEN|
+--------+
4rowsinset(0.00sec)
以下是先按特定值排序的查询-mysql>select*fromDemoTable849orderbyfield(Color,'RED','GREEN','BLUE','ORANGE');
这将产生以下输出-+--------+
|Color|
+--------+
|RED|
|GREEN|
|BLUE|
|ORANGE|
+--------+
4rowsinset(0.00sec)