Home >Database >Mysql Tutorial >Mysql：把指定数据行排在前面_MySQL
Mysql：把指定数据行排在前面_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:08:521502browse
如果只是一条数据行，可以这样：
SELECT * FROM user ORDER BY user_id<>7,score DESC;
主要是“user_id7”，就会把用户id为7的排在前面。
如果是多条数据行：
SELECT * FROM user ORDER BY user_id NOT IN(7,8,9),score DESC;
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：配置Mysql Cluster时出错Unable to connect with connect string_MySQLNext article：解决mysql启动时报The server quit without updating PID file_MySQL