select id from table where (num,name) in ((num1,‘name1‘),(num2,‘name2‘))
select in关键字查询匹配多个字段
原文：https://www.cnblogs.com/jaxlove-it/p/11393600.html
