a=1
b=2
c=3
d=4
e=5
f=6
...
共m个条件满足指定的n个条件select * from table_1 where (a=1,b=2,c=3) or (a=1,b=2,d=4) or (b=2,c=3,d=4) or...表中大约有7万数据
b=2
c=3
d=4
e=5
f=6
...
共m个条件满足指定的n个条件select * from table_1 where (a=1,b=2,c=3) or (a=1,b=2,d=4) or (b=2,c=3,d=4) or...表中大约有7万数据
select * from table_1 where (a=1,b=2,c=3)
union select * from table_1 where (b=2,c=3,d=4)
union ....如果返回记录很多,全表扫描说不定是最快的方式,再说7万条记录也不多,:)