mybatis中的动态语句中多条件or如何书写
1.说明
sql如下:
SELECT COUNT(DISTINCT t.contract_id) FROM `plm`.`t_plm_contract_monitor` t WHERE 1=1 ANd (t.whole_id_one in ( 77 ) or t.whole_id_five in ( 77 ) or t.whole_id_six in ( 50563002294 )) AND t.is_deleted = 0
说明:
t.whole_id_one