正常情况下MySQLin的排序会按照数字的顺序进行排序 123456
例 select goods_id,goods_name,goods_keywords,order_price,goods_thumb from goods where goods_id IN (183,104,36,156,87,19,15,153)
得出的结果会按照 数字的大小进行排序,但是如果需要根据自定义的大小进行排序改怎么办
select goods_id,goods_name,goods_keywords,order_price,goods_thumb from goods where goods_id IN (183,104,36,156,87,19,15,153) order by field(goods_id,183,104,36,156,87,19,15,153)