mybatis ORDER BY FIND"/>
mybatis ORDER BY FIND
先看代码,我想根据传递的questionIndex进行排序
<select id="selectListByConditionsOrder" resultMap="BaseResultMap">SELECT *FROM survey_xx${ew.customSqlSegment}AND deleted_at IS NULL<if test="questionIndex != null">ORDER BYFIND_IN_SET(question_index, #{questionIndex})</if></select>
结果运行起来怎么也不对,最终发现是因为传递过来的字符串有问题
之前是
pageArray.toString()
改成
pageArray.join(",")
就好了,真是诡异,我还纳闷为啥navicat里测试没问题用mybatis就有问题呢。
JSONArray pageArray
hutool的一个json
更多推荐
mybatis ORDER BY FIND
发布评论