mybatis 下 mysql in查询按照参数顺序输出结果

若是直接

SELECT * FROM project_celiangbuwei where clbwid in ( 7 , 11 , 20 , 4 ) 

则输出结果为：

4 净胸围
7 净臀围
11 肩宽
20 横裆

使用Field函数排序后：

SQL:

SELECT * FROM project_celiangbuwei where clbwid in ( 7 , 11 , 20 , 4 )  ORDER BY FIELD(clbwid,7,11,20,4)

输出结果：

7 净臀围
11 肩宽
20 横裆
4 净胸围

mybatis 设置：

	<select id="findByIds"  resultType="com.bwhx.eruler.bean.CeliangBuwei">
		SELECT *   FROM project_celiangbuwei 
		where 
		clbwid in 
		<foreach collection="array" index="index" item="item" open="(" separator=","  close=")" >
		    #{item}  
		  </foreach> 
		  order by 
		  field(
		  clbwid,
		  <foreach collection="array" index="index" item="item"   separator=","    >
		    #{item}  
		  </foreach> 
		  )
	</select>