mybatis ORDER BY FIND

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