使用LIKE和CONCAT模糊查询时间段数据 - MyBatis SQL语句优化

要模糊查找某个时间段的数据，可以使用LIKE运算符结合通配符来实现。以下是修改后的SQL语句：

    SELECT s.sid,
    staff.staffname,
    b1.branchname,
    d1.deptname,
    r1.rolename,
    b2.branchname as newbranchname,
    d2.deptname as newdeptname,
    r2.rolename as newrolename,
    s.transfertime,
    s3.staffname as st
    FROM shopkeeperchange s
    left JOIN staff ON staff.staffid = s.staffid
    left JOIN staff s3 ON s3.staffid = s.transferper
    LEFT JOIN branch b1 ON b1.branchid = s.branchid
    LEFT JOIN department d1 ON d1.deptid = s.deptid
    LEFT JOIN role r1 ON r1.roleid = s.roleid
    LEFT JOIN branch b2 ON b2.branchid = s.newbranchid
    LEFT JOIN department d2 ON d2.deptid = s.newdeptid
    LEFT JOIN role r2 ON r2.roleid = s.newroleid
    LEFT JOIN stafftransfer st ON s.staffid = st.staffid
    
        
            s.transfertime LIKE CONCAT('%',#{transfertime},'%')
        
        st.state = 2 AND b1.branchname != '' AND b2.branchname != ''
    

在上述代码中，使用了LIKE和CONCAT函数来模糊匹配transfertime字段。CONCAT函数用于将通配符与transfertime值进行连接，从而实现模糊匹配。%表示匹配0个或多个字符。