Where is sample for combination condition like AND/OR?

[trungdoviet]

Hi team i have requirement to write SQL like:

Select * from table_a where col1 IN (1,2,3) OR col2 IN ("x", "y", "z")

How to write this one with mybatis-plus?

[qiuzhihui1990]

Hello. I think you can try the following:

in("col1", collect1).or().in("col2",collect2)