帮忙给看下一条sql语句

来源：百度知道 编辑：UC知道 时间：2024/06/17 23:36:57
select top 6 gongqiuid,title,classid,updatetime,cityinfo from recycle_gongqiu
where classid in '9' and title like '%铜皮%' order by updatetime desc

查询时提示'9' 附近有语法错误，是不是in的用法不对？in后面的有可能是'9'、'10'或者'9，10';该怎么改才对呀？

in (9，10)
如果classid数据类型不是数字而是字符的则用
in ('9','10')

in 后面应该是个范围
select top 6 gongqiuid,title,classid,updatetime,cityinfo from recycle_gongqiu
where classid in '(9,10)' and title like '%铜皮%' order by updatetime desc

where classid in (9)

select top 6 gongqiuid,title,classid,updatetime,cityinfo from recycle_gongqiu
where classid in ('9') and title like '%铜皮%' order by updatetime desc

--如果多个值，则用in('9','……')

加个括号试试
where (classid in '9') and