例:
<choose>
<when test="sidx != null and sidx.trim() != '' ">
order by ${sidx} ${order}
</when>
<otherwise>
ORDER BY FIELD(friendRingId, #{friendId}) desc
// 我这里主要想想让指定得数据排在最前面
</otherwise>
</choose>
网上说明:https://www.cnblogs.com/code-g/p/9542353.html
SELECT `user` FROM user WHERE `user_status` in (0,1,2,3) ORDER BY FIELD(`user_status`,1,0,2,3);
这样就可以将取出来的数据按照 1>0>2>3 的顺序排序了