转载自http://blog.linuxphp.org/archives/1588/
先看下mysql的默认排序
select id from article where id in(63261,63262,63269);
+-------+
| id |
+-------+
| 63261 |
| 63262 |
| 63269 |
+-------+
如果我想63262在第一个63261在最后一个怎么办？
select id from article where id in(63261,63262,63269) order by field(id,63262,63269,63261);
+-------+
| id |
+-------+
| 63262 |
| 63269 |
| 63261 |
+-------+
where id in用 order by field 保持排序
原文：http://www.cnblogs.com/doubilaile/p/4643319.html
