摘要:
mysql> select * from test where id in(2,5,4,13,6) order by field(id,2,5,4,13,6) limit 0,6;+----+-------+------+| id | name | sex |+----+-------+------+| 2 | zj_2 | 2 || 5 | zj_5 | 2 || 4 | zj_4 | 2 || 13 | zj_13 | 2 || 6 | zj_6 | 2 |+----+-------+------+有利有弊,order by 和in 我们都... 阅读全文