mybatis模糊查询

public User queryUserByLike(@Param("arg") String arg);

方式一：

<select id="queryUserByLike" resultType="org.example.entity.User">
        select * from t_user where name like '%${arg}%'
</select>

 

方式二：

    <select id="queryUserByLike" resultType="org.example.entity.User">
        select * from t_user where name like concat('%',#{arg},'%')
    </select>

 

方式三：

    <select id="queryUserByLike" resultType="org.example.entity.User">
        select * from t_user where name like "%"#{arg}"%"
    </select>