SQL模糊查询， `t_department`.`CODE` LIKE #{code__}

Question

 @Select(value=" SELECT CAST(SUBSTRING(CESHIRIQI,1,4) AS CHAR),`t_department`.`NAME`,ROUND(AVG(CESHICHENGJI),2) "
        + " AS pjcj FROM `t_datacenter`,`t_department` WHERE `t_datacenter`.`CESHIXIANGMUMINGCHENG`=#{xiangmu} "
        + " AND `t_department`.`CODE` = SUBSTRING(`t_datacenter`.`JIGOUDAIMA`, 1, 6) AND SUBSTRING(CESHIRIQI,1,4) BETWEEN #{year} "
        + " AND #{lastyear} AND `t_department`.`CODE` LIKE #{code__} GROUP BY  CAST(SUBSTRING(CESHIRIQI,1,4) AS CHAR),`t_department`.`NAME`  ")
 List<Map<String, Object>>SelectQu(@Param("xiangmu") String xiangmu,@Param("year") String year, @Param("lastyear") String lastyear,@Param("code")String code);

  `t_department`.`CODE` LIKE #{code__}   这句话我是想写成模糊查询。应该怎么写

Answer 1

注入的时候 自带 % 百分号。 String code = "张三"; code = "%"+code+"%"; 然后在吧code注入进去就行了