V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member Sign In
This topic created in 3813 days ago, the information mentioned may be changed or developed.
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 Nov 17, 2015
SELECT * FROM comments where postId = 92057 AND (auditBy IS NOT NULL or (auditBy IS NULL AND userId = 1111));
|
 |
2
corboy OP 自己已解决，谢谢。
|
 |
3
barbery Nov 17, 2015
要么条件合并： 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 Nov 17, 2015
SELECT * FROM comments where postId = 92057 AND auditBy IS NOT NULL OR (auditBy IS NULL AND userId = 1111);
这样 OK 吗？ |
 |
5
ixiaozhi Nov 17, 2015
SELECT * FROM comments where postId = 92057 AND ( auditBy IS NOT NULL ) OR ( auditBy IS NULL AND userId = 1111)
|
1 |
9
TangMonk Nov 18, 2015
UNION
|
Select Language