这是一个创建于 3714 天前的主题，其中的信息可能已经有所发展或是发生改变。
SELECT * FROM comments where postId = 92057 AND auditBy IS NOT NULL;
SELECT * FROM comments where postId = 92057 AND auditBy IS NULL AND userId = 1111;
 |
1
qsl0913 2015 年 11 月 17 日
SELECT * FROM comments where postId = 92057 AND (auditBy IS NOT NULL or (auditBy IS NULL AND userId = 1111));
|
 |
2
corboy OP 自己已解决，谢谢。
|
 |
3
barbery 2015 年 11 月 17 日
要么条件合并： SELECT * FROM comments where postId = 92057 AND auditBy IS NOT NULL OR (auditBy IS NULL AND userId = 1111)
要么链接来执行： SELECT * FROM comments where postId = 92057 AND auditBy IS NOT NULL UNION ALL SELECT * FROM comments where postId = 92057 AND auditBy IS NULL AND userId = 1111; |
 |
4
lingdong 2015 年 11 月 17 日
SELECT * FROM comments where postId = 92057 AND auditBy IS NOT NULL OR (auditBy IS NULL AND userId = 1111);
这样 OK 吗？ |
 |
5
ixiaozhi 2015 年 11 月 17 日
SELECT * FROM comments where postId = 92057 AND ( auditBy IS NOT NULL ) OR ( auditBy IS NULL AND userId = 1111)
|
1 |
9
TangMonk 2015 年 11 月 18 日
UNION
|
Select Language