mybatis-plus or and ǶÌ×

QueryWrapper<User> wrapper = new QueryWrapper<>();

wrapper.like("content", searchValue);
wrapper.and(wrapper1 -> wrapper1.eq("to_id",chatId).and(wrapper2 -> wrapper2.eq("from_id",fromId))
        .or((wrapper3 -> wrapper3.eq("to_id",fromId).and(wrapper4 -> wrapper4.eq("from_id",chatId)))));

ת»¯³ÉsqlÓï¾ä :

select *

from im_message

where

((from_id="cb0c145a6c104497942525f8c984f9d9" and to_id="c44d95352ccac43b85607038dd8ac2f2") or

(from_id="c44d95352ccac43b85607038dd8ac2f2" and to_id="cb0c145a6c104497942525f8c984f9d9")) and

content like "%»ðÓ°%";