Mysql 按照某字段顺序查询

Mysql 按照某字段顺序查询

Mysql ，查询不带 ORDER BY，会根据主键来排序，从小到大；

带 ORDER BY 的升序，降序：

SELECT * FROM USER ORDER BY `user_id` ASC   ---  升序
SELECT * FROM USER ORDER BY `user_id` DESC  ---  降序

查询结果按照指定的 id 列进行排序：

SELECT * FROM USER ORDER BY FIELD(`id`, 5, 3, 7, 1)