SELECT `id`,`name` FROM `table` WHERE `id` IN (1000,1009,1004,1002,1007)
这样读取的数据返回时是按照 id 从小到大顺序返回的。
想要按照自己输入的id顺序获取返回数据应该这么写:
SELECT `id`,`name` FROM `table` WHERE `id` IN (1000,1009,1004,1002,1007) ORDER BY FIND_IN_SET (`id`, '1000,1009,1004,1002,1007')
搞定,收工