SELECT
*
FROM
test_produce
WHERE
(publish_platform = 1
AND (
play_count IS NULL
OR digg_count IS NULL
OR share_count IS NULL
OR comment_count IS NULL
)) or
(publish_platform = 3
AND (
play_count IS NULL
OR digg_count IS NULL
OR share_count IS NULL
OR comment_count IS NULL
))
;
1 个回复
thewind
赞同来自: zhangye 、zhangdi