febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpAccessoryServiceImpl.java
@@ -142,8 +142,10 @@ @Override public void accept(QueryWrapper<EmpAccessoryVO> wrapper) { for (int i = 0; i < certificates.length; i++) { String ageBtn = certificates[i]; wrapper.or().like("a.certificateList", ageBtn); // String ageBtn = certificates[i]; // wrapper.or().like("a.certificateList", ageBtn); String ageBtn = "|" + certificates[i] + "|"; wrapper.gt("LOCATE('"+ageBtn+"',CONCAT('|',replace( certificateList, ',', '|,|'),'|'))",0); } } };