MySQL where NOT IN where one

Question

我有论坛的线程表。我不想选择隐藏论坛的线程，但除了用户自己的线程。我的查询就像这样，在$hiddenforums变量中隐藏论坛i，所以我还想选择用户自己的主题；

SELECT tid,uid,username
    FROM ".TABLE_PREFIX."threads
    WHERE fid NOT IN ($hiddenforums) /* HERE WHAT I WANT */ EXCEPT WHERE uid = $userownid /* */
    ORDER BY dateline
    DESC LIMIT 10

Answer 1

这是你想要的吗？

WHERE (fid NOT IN ($hiddenforums) OR uid = $userownid)