mysql按指定顺序排序

select id,name from htms_center_freight_users  where id in(114,112,91,223,134) order by  find_in_set(id,'114,91,223,134,112');

  

posted @ 2017-07-26 17:24  佚小名  阅读(946)  评论(0编辑  收藏  举报