192 Mysql查询的数据的顺序按in里面的顺序来排序

https://blog.youkuaiyun.com/umbrellasoft/article/details/81664938

可以使用mysql的field()函数进行自定义排序

SELECT
    *
FROM
    tb_merchant AS t
WHERE
    t.id IN (20,16,35,100,201,131) order by FIELD(id, 20,16,35,100,201,131);