筛选同时符合多个字段指定条件记录的SQL

 

SELECT * FROM `TABLE` WHERE (column1+':'+column2) in (column1Value1+':'+column2Value1,column1Value2+':'+column2Value2);

 

SELECT * FROM `view_action_logs` WHERE (column1,column2) in (('column1Value1','column2Value1'),('column1Value2','column2Value2'));

 

PS : 注意区分查找字段的类型

 

 

End.