Select * from table where 1=1 and (cs) doc_code, cs. Transaction_qty) in ((' 191225150215014 ', 2), (' 191225164806018 ', 3))
This in a while, into mybatis how, at the back of the code and quantity if the corresponding, thank you!

CodePudding user response:

 
Select * from table where 
Cs. Doc_code in 
# {cs. Doc_code} 
 
And 
Cs. Transaction_qty in 
# {cs. Transaction_qty} 
 
 

Grammar is such, if not, change according to your own circumstances, set name is you the name of the parameter in the dao interface method