Mybatis中的模糊查询语法

案例一：#{}            业务层加上%%

mapper.java

@Repository
public interface Demo{
    long getCount(@Param("id")String id,@Param("keyword")String keyword);
}

mapper.xml

<select id="getCount" resultType="java.lang.Long">
    SELECT COUNT(*),b.nickname
    FROM tableA AS a
    <if test="keyword != null and keyword.length()>0">
        JOIN tableB AS b
        ON b.id = a.id
        AND b.nickname LIKE #{keyword}
    </if>
    <where>
        <if test="id != null">
           a.id = #{id}
        </if>
    </where>
</select>

案例二：CONCAT('%',#{keyword},'%')

Demo.java

public interface Demo{
    List<String> getFriendWxIdByWcId(@Param("wcId") String