求一简单select语句
表中有一字段:col_text(varchar(100))
存储形式为: 张三,李四,王府井,丰收年,欧阳李修,杨柳...
给出某个人的名称, str_name 找出表中所有该字段含str_name的记录
select * from tab_text
where ...(怎么写)
谢谢!
[解决办法]
select * from tab_text
where patindex( '%王府井% ',str_name )> 0
[解决办法]
Select * from tab_text
Where CharIndex( ', ' + '张三 ' + ', ', ', ' + col_text + ', ') > 0
[解决办法]
select * from tab_text
where charindex( ',str_name, ', ', '+col_text+ ', ')> 0
[解决办法]
Select * from tab_text
Where ', ' + col_text + ', ' Like '%, ' + '张三 ' + ',% '
[解决办法]
select * from tab_text where col_text like '%str_name% '
