求一个 mysql 语句同时满足两列的条件进行筛选

[cs5117155]

SELECT `o`.`id`,`o`.`pay_type`,`o`.`operation_id`,`o`.`order_no` FROM `pay_auth_log` `o` WHERE  `o`.`status` < 99  AND `pay_status` <= 1;

这条语句怎么改为，当pay_type=2 && operation_id为空的时候就过滤改条信息，但是pay_type=1时,operation_id为空时，该记录需要展示出来。

[eason1874]

`pay_type` = 1 OR (`pay_type` = 2 AND `operation_id` IS NOT NULL)

[easonzhang666]

and ((xx ) or (xx))

[cs5117155]

good

[deargodfrey]

mysql 能用 not 吗如果有的话就只要加个 AND NOT (paytype=2 and operationid is null)

[cs5117155]

@deargodfrey 这个也不错