mysql - 我的 sql 语法错误 1064 - 找不到问题所在

Question

当我运行这个查询时出现这个错误信息

SELECT name,state FROM customers WHERE state ‌IN ('CA','NC','NY')

错误SQL 查询:文档

SELECT name, state
FROM customers
WHERE state ‌IN(

'CA',  'NC',  'NY'
)
LIMIT 0 , 30

MySQL 说:文档

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '‌in ('CA','NC','NY') LIMIT 0, 30' at line 1

我去看看http://dev.mysql.com/doc/refman/5.6/en/error-messages-server.html但我还是找不到原因

谢谢

Answer 1

去掉IN之后的=

SELECT name, state FROM customers 
WHERE state ‌IN ('CA','NC','NY')