mysql 要按in(1,3,13,2,33,79,66)顺序显示方法
select * from tb_user where fid IN (10,33,22,76,13,44) order by FIND_IN_SET(fid,'10,33,22,76,13,44');
select * from tb_user where fid IN (10,33,22,76,13,44) order by field(fid,10,33,22,76,13,44);
select * from tb_user where fid IN (10,33,22,76,13,44) order by FIND_IN_SET(fid,'10,33,22,76,13,44');
select * from tb_user where fid IN (10,33,22,76,13,44) order by field(fid,10,33,22,76,13,44);