mybatis多条件模糊查询

<select id="selectUserList" parameterType="cn.vipkes.dao.dto.param.UserListDto" resultType="cn.vipkes.dao.dto.result.UserListResult">
		SELECT USER_NAME as userName
		FROM USER
		WHERE DEL_FLG = 0
		<if test="userName != null and userName != ''">
			AND USER_NAME LIKE '%'||#{userName}||'%'
		</if>
		<if test="address != null and address != ''">
			AND ADDRESS LIKE '%'||#{address}||'%'
		</if>
	</select>

如上，通过用户名（username）和地址（address）多条件模糊查询。

注意的是，想要拼接 %  那就像如上方式去写，蛮好的，哈哈~