select * from m_admins where admin_id in ('10003','10001','10005') order by substring_index('10003,10001,10005', admin_id, 1);
select * from m_admins where admin_id in ('10003','10001','10005') order by find_in_set(admin_id, '10003,10001,10005')
select * from m_admins where admin_id in ('10003','10001','10005') order by field(admin_id, '10003','10001','10005');
select * from m_admins where admin_id in ('10003','10001','10005') order by find_in_set(admin_id, '10003,10001,10005')
select * from m_admins where admin_id in ('10003','10001','10005') order by field(admin_id, '10003','10001','10005');
以上三种方法都可行。
Mysql版本5.6.23