mysql 按照指定顺序排序

SELECT `ID` FROM wp_posts WHERE `ID` in (1,2,3,4,5) ORDER BY FIELD(`ID`,5,4,3,1,2); 

 

posted @ 2018-09-18 14:20  bug_hua  阅读(840)  评论(0)    收藏  举报