mysql - SQL如何在NOT IN中使用很多语句

Question

我尝试执行这个查询:

SELECT ISBN FROM table2 WHERE 
NOT IN ISBN=('8426429807','840149768X')
group by ISBN 
ORDER BY AVG(`Book-Rating`) DESC LIMIT 10

但是我得到这个形状的错误

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IN ISBN=('8426429807','840149768X')

如何在 Not In 中使用多个 isbn

Answer 1

Not In()语法是:

expr NOT IN (value,...)

基本上，列/表达式应该位于 Not In 之前，并且您不使用 = 运算符。应该是:

SELECT ISBN
FROM table2
WHERE ISBN NOT IN ('8426429807',
                   '840149768X')
GROUP BY ISBN
ORDER BY AVG(`Book-Rating`) DESC
LIMIT 10

---

另一种编写相同查询的方法是使用 NOT (expr IN (value, ...)):

SELECT ISBN
FROM table2
WHERE NOT (ISBN IN ('8426429807',
                    '840149768X'))
GROUP BY ISBN
ORDER BY AVG(`Book-Rating`) DESC
LIMIT 10