select in关键字查询匹配单个字段
select id from table where name in('name1','name2')
select in关键字查询匹配多个字段
select id from table where (num,name) in ((num1,'name1'),(num2,'name2'))
select in关键字查询匹配单个字段
select id from table where name in('name1','name2')
select id from table where (num,name) in ((num1,'name1'),(num2,'name2'))