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);

原文地址:https://www.cnblogs.com/lh460795/p/2985737.html