方法1:concat
<if test="nickname != null and nickname != ''">
AND nickname LIKE concat('%',#{nickname,jdbcType=VARCHAR},'%')
</if>
方法2:${}
<if test="nickname != null and nickname != ''">
AND nickname LIKE '%${nickname,jdbcType=VARCHAR}%'
</if>
方法3:#{}
<if test="nickname != null and nickname != ''">
AND nickname LIKE "%"#{nickname,jdbcType=VARCHAR}"%"
</if>
更多推荐
mybatis中xml开发like的几种写法
发布评论