mybatis-plus多关键字查询

QueryWrapper<DTO> query = Wrappers.query();
     query.and(w -> w.like("TITLE",dto.getGeneral())
              .or().like("AUTHOR",dto.getGeneral())
              .or().like("LSSUING",dto.getGeneral()));
query.orderByDesc(true , "CREATE_DATE");
IPage<YjYjzskDTO> dtoPage = Mapper.searchPage(page, query);

输出的SQL：

SELECT * FROM biaoming
WHERE (TITLE LIKE '%学院%' OR AUTHOR LIKE '%学院%' OR LSSUING LIKE '%学院%') 
ORDER BY CREATE_DATE DESC