索引精确匹配逗号
select * from INF_ARTICLE where CONTAINS(TITLE,',12,') order by ID desc
我要查找TITLE里包含,12,的内容
结果说是逗号有问题,我把逗号去了到是可以,可我查的内容要包含逗号的,求大侠们指教
[解决办法]
select * from INF_ARTICLE where CONTAINS(TITLE,'",12,"') order by ID desc
发布时间: 2013-01-05 15:20:39 作者: rapoo
索引精确匹配逗号
select * from INF_ARTICLE where CONTAINS(TITLE,',12,') order by ID desc
我要查找TITLE里包含,12,的内容
结果说是逗号有问题,我把逗号去了到是可以,可我查的内容要包含逗号的,求大侠们指教
[解决办法]
select * from INF_ARTICLE where CONTAINS(TITLE,'",12,"') order by ID desc