php - NOT IN 不工作 MYSQL

Question

我正在尝试使用搜索查询在我的网站上提供搜索功能，但我不希望获得具有 contestId='-1' 的电影。

这是我的搜索查询:

SELECT * FROM film WHERE  MATCH (title, otherInfo, inspiration, description,directedBy,
keywords,producer) AGAINST ('$searchresults' IN NATURAL LANGUAGE MODE )
and contestId not in (select contest_id from contest where contest_id !='-1' ) 
OR title LIKE 'ho%' OR title LIKE '%ho' and isApproved=1 order by film_id desc limit 1

仍然通过 contestId='-1' 获得结果。

请帮忙。提前致谢。

Answer 1

SELECT   *
FROM     film
WHERE    MATCH (title, otherinfo, inspiration, description,directedby, keywords,producer) against ('$searchresults' IN NATURAL language mode )
AND      contestid NOT IN
         (
                SELECT contest_id
                FROM   contest
                WHERE  contest_id ='-1' )
AND     (
                  title LIKE 'ho%'
         OR       title LIKE '%ho' )
AND      isapproved=1
ORDER BY film_id DESC
LIMIT    1

几个错误

• 从竞赛 WHERE racing_id !='-1' 中选择 racing_id 应为 从竞赛 WHERE racing_id ='-1' 中选择竞赛_id。
• AND racingId NOT IN (... ) OR title LIKE 'ho%' OR title LIKE '%ho' .... 即使有 contestId = - 也将包含记录1.. title LIKE 'ho%' 或 title LIKE '%ho' 应包含在 AND 内。就像AND(标题LIKE'ho％'或标题LIKE'％ho')