select * from tables where id in (2,3,1) 返回的数据是按id 1,2,3排序的，如果你希望返回的按照in给的顺序排序就需要用到order by field了 select * from tables where id in (2,3,1) ORDER BY field(id, 2, 3, 1)

阅读全文>>