22,209
社区成员
发帖
与我相关
我的任务
分享
declare @TagName varchar(50)
set @TagName='国庆60周年'
select * from Article
where charindex(@TagName,Tag)>0
and
(charindex(@TagName,Tag)=1 or (charindex(@TagName,Tag)>1 and SUBSTRING(Tag,charindex(@TagName,Tag)-1,1)=','))
and
((charindex(@TagName,Tag)+LEN(@TagName)-1=LEN(Tag)) or SUBSTRING(Tag,charindex(@TagName,Tag)+LEN(@TagName),1)=',')
create table Article(id int,Title nvarchar(20),Tag nvarchar(20))
insert into article select 1,'新闻1','国庆60周年,国庆,60周年'
insert into article select 2,'新闻2','fagA,tagB,tagC'
insert into article select 3,'新闻3','国庆60周年'
go
declare @searchstr nvarchar(10)
set @searchstr='国庆'
select * from article where ','+tag+',' like '%,'+@searchstr+',%'
go
drop table article
/*
id Title Tag
----------- -------------------- --------------------
1 新闻1 国庆60周年,国庆,60周年
(1 行受影响)
*/
create table Article(id int,Title nvarchar(20),Tag nvarchar(20))
insert into article select 1,'新闻1','国庆60周年,国庆,60周年'
insert into article select 2,'新闻2','fagA,tagB,tagC'
insert into article select 3,'新闻3','国庆60周年'
go
declare @searchstr nvarchar(10)
set @searchstr='国庆'
select * from article where charindex(','+@searchstr+',',','+tag+',')>0
go
drop table article
/*
id Title Tag
----------- -------------------- --------------------
1 新闻1 国庆60周年,国庆,60周年
(1 行受影响)
*/
create table Article(id int,Title nvarchar(20),Tag nvarchar(20))
insert into article select 1,'新闻1','国庆60周年,国庆,60周年'
insert into article select 2,'新闻2','fagA,tagB,tagC'
insert into article select 3,'新闻3','国庆60周年'
go
declare @searchstr nvarchar(10)
set @searchstr='国庆'
select * from article where charindex(','+@searchstr+',',tag)>0
go
drop table article
/*
id Title Tag
----------- -------------------- --------------------
1 新闻1 国庆60周年,国庆,60周年
(1 行受影响)
*/
where charindex(','+@TagName+',', ','+Tag+',')>0
select * from article where charindex(',国庆,',','+tag+',')>0