[大数据]mybatis中xml开发like的几种写法

方法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>