mybatis-plus使用FIND_IN_SET

xxxQueryWrapper.eq("is_deleted","0").apply(deptUser.getDeptId() != null,"dept_id = '"+deptUser.getDeptId()+"' or FIND_IN_SET ( dept_id , '"+deptUser.getDeptId()+"' )");
posted @ 2021-10-28 17:50  LHX2018  阅读(1533)  评论(0编辑  收藏  举报