mysql IN子句将值视为未知列错误

SELECT `daycare attendance table`.Date, `daycare attendance table`.StartTime, `daycare attendance table`.EndTime, `daycare attendance table`.DropoffID, `daycare attendance table`.PickupID, `daycare attendance table`.LastName, `daycare attendance table`.FirstName, `daycare attendance table`.ItemNo, Students.SubStatus
FROM `daycare attendance table`
LEFT JOIN Students
ON `daycare attendance table`.StudentID = Students.StudentID
WHERE Students.SubStatus IN (ka)
ORDER BY `daycare attendance table`.ItemNo DESC LIMIT 10000

Students.SubStatus IN (ka)

当我运行查询时,mysql返回的错误是 Unknown column 'ka' in 'where clause'

为什么会这样想 ka

解决了的

显然,我从未在in子句中使用过字符串。你必须在一个字符串周围加上单引号