mysql find_in_set() 对结果进行排序

selecta.*
from shop_members a
ORDER BY
FIND_IN_SET(a.ShopID,'2,5,7,1');
-- 查询结果，会按照 ShopID 分别是 2,5,7,1 的顺序进行排序