if OBJECT_ID('TBC_EventInfo','U') is not null
drop table TBC_EventInfo
go
create table TBC_EventInfo
(
eventID int primary key,
eventName varchar(200),
VideoUrl varchar(256),
KeywordSet varchar(100)
)

--数据
insert into TBC_EventInfo values(1,'早期教育','www.csdn.net/a.wma',',1,2,3,4,')
insert into TBC_EventInfo values(2,'营养性疾病','www.csdn.net/a.wma',',1,3,5,')
insert into TBC_EventInfo values(3,'西欧早期教育','www.csdn.net/a.wma',',1,7,8,9,')
insert into TBC_EventInfo values(4,'婴幼儿生理特点','www.csdn.net/a.wma',',4,6,')
insert into TBC_EventInfo values(5,'理解孩子的成长','www.csdn.net/a.wma',',5,7,')
insert into TBC_EventInfo values(6,'让我们共同分享','www.csdn.net/a.wma',',6,9')
insert into TBC_EventInfo values(7,'社会适应能力','www.csdn.net/a.wma',',10,7,')
insert into TBC_EventInfo values(8,'学前脑开发','www.csdn.net/a.wma',',5,9,')
insert into TBC_EventInfo values(9,'教养方式','www.csdn.net/a.wma',',2,4,')
insert into TBC_EventInfo values(10,'行为课程的开发','www.csdn.net/a.wma',',6,12,')

DECLARE @STR VARCHAR(8000)
SELECT @STR='5,7,9'

IF @STR LIKE ',%' SET @STR=STUFF(@STR,1,1,'')
IF @STR LIKE '%,' SET @STR=LEFT(@STR,LEN(@STR)-1)
SET @STR='('',''+KeywordSet+'','' LIKE ''%,'+REPLACE(@STR,',',',%'' OR '',''+KeywordSet+'','' LIKE ''%,')+',%'')'

EXEC ('SELECT * FROM TBC_EventInfo WHERE '+@STR)
/*
2    营养性疾病    www.csdn.net/a.wma    ,1,3,5,
3    西欧早期教育    www.csdn.net/a.wma    ,1,7,8,9,
5    理解孩子的成长    www.csdn.net/a.wma    ,5,7,
6    让我们共同分享    www.csdn.net/a.wma    ,6,9
7    社会适应能力    www.csdn.net/a.wma    ,10,7,
8    学前脑开发    www.csdn.net/a.wma    ,5,9,
*/

------解决方案--------------------
SQL code
--建表SQL语句
if OBJECT_ID('TBC_EventInfo','U') is not null
drop table TBC_EventInfo
go
create table TBC_EventInfo
(
eventID int primary key,
eventName varchar(200),
VideoUrl varchar(256),
KeywordSet varchar(100)
)

--数据
insert into TBC_EventInfo values(1,'早期教育','www.csdn.net/a.wma',',1,2,3,4,')
insert into TBC_EventInfo values(2,'营养性疾病','www.csdn.net/a.wma',',1,3,5,')
insert into TBC_EventInfo values(3,'西欧早期教育','www.csdn.net/a.wma',',1,7,8,9,')
insert into TBC_EventInfo values(4,'婴幼儿生理特点','www.csdn.net/a.wma',',4,6,')
insert into TBC_EventInfo values(5,'理解孩子的