MyBatis中模糊查询使用CONCAT('%',#{str},'%')出错的解决

<select id="getByPage" resultType="com.test.domain.Users" parameterType="com.test.Param">
SELECT * FROM tb_users where isdeleted=1 
<if test="name!=null and name!=''">
     AND nickname LIKE CONCAT('%', '${name}', '%')
</if>
ORDER BY createtime DESC
limit #{fromIndex},#{count}
</select>