模糊查询拼接like加条件
SELECT t_leave_application.* FROM t_leave_application
LEFT JOIN sys_user ON sys_user.id = t_leave_application.stu_id
WHERE sys_user.`name` LIKE concat('%',#{leaveApplication.stuName},'%')
模糊查询拼接like加条件
SELECT t_leave_application.* FROM t_leave_application
LEFT JOIN sys_user ON sys_user.id = t_leave_application.stu_id
WHERE sys_user.`name` LIKE concat('%',#{leaveApplication.stuName},'%')