SQL 错误 : Operand should contain 1 column(s)

Question

我有这个查询，我收到错误“操作数应该包含 1 列”，我的查询有什么问题？

SELECT * FROM contact AS b WHERE b.id IN 
(
    SELECT * 
    FROM contact AS e 
    WHERE e.firstname LIKE ? 
    OR e.lastname LIKE ? 
    OR e.email LIKE ? 
    OR e.phone LIKE ? 
    OR e.company LIKE ? 
    OR e.profession LIKE ? 
    OR e.mobile LIKE ?
)

Answer 1

IN 运算符需要一个与您正在比较的内容相匹配的值列表:您的情况下的 columnb.id。所以更换这个

WHERE b.id IN (SELECT * 

有了这个

WHERE b.id IN (SELECT id