Mybatis多字段关键字模糊查询

Mybatis多字段关键字模糊查询

<select id="selectAll" resultType="com.test.pojo.user">
        SELECT *
        FROM user
  		<where>
          <if test="keyword!='' and keyword!=null">
              and CONCAT(username,sex,nickname) like CONCAT{'%',keyword,'%'}
          </if> 
        </where>