模糊查询like两种使用方式

在Java中,把like的内容组装好,把这个内容传入sql语句.

    public List quaryByName1(String uname) {
        String name = "%" + uname +"%";//Java中组装好
        return crudDao.quaryByName1(name);
    }

    
        select * from student where `name` like #{name}
    

select * from student where `name` like concat("%",#{name},"%")

或

select * from student where `name` like "%" #{name} "%"