Home >Database >Mysql Tutorial >MySQL 下不规则排序
MySQL 下不规则排序
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-07 17:01:331411browse
SQL查询语句如下：select * from table where (ID = 10) or (ID = 32) or (ID = 22) or (ID = 76) or (ID = 13) or (ID = 44)让结
SQL查询语句如下：
select * from table where (ID = 10) or (ID = 32) or (ID = 22) or (ID = 76) or (ID = 13) or (ID = 44)
让结果按10，32，22，76，13，，44的顺序检索出来,请问如何书写？ （sql能力）
select * from table where (ID = 10) or (ID = 32) or (ID = 22) or (ID = 76) or (ID = 13) or (ID = 44) order by field(ID,10,32,22,76,13,44)
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：Oracle 11g default profile 默认启用密码过期180天 ORA-28001错误处理Next article：Oracle 9i导出Oracle 10g的大字段