1.第一种用or select * from ts_order where (a!=10 or b!=20) 2.第二种用not select * from ts_order where not (a=10 and b=20)