LIKE CONCAT(‘%’,#{模糊查询},‘%’) @Select("SELECT DISTINCT(u.user_id) AS userId,u.user_name AS userName FROM user_info u " + "LEFT JOIN user_duty ud ON ud.user_id = u.user_id WHERE ud.duty_type = 'D' AND u.user_name LIKE CONCAT('%',#{username},'%')")