mysql查询结果与in保持一致 语法 order by field(列名, xxx1, xxx2,***) 举例 正常使用in查询,发现不一样 排序了,保持一致 SELECT * FROM `user` WHERE phone_number in ('17761006105','17761006101','17761006103','17761006109','17761006102') ORDER BY FIELD(phone_number,'17761006105','17761006101','17761006103','17761006109','17761006102');