一条SQL语句,匹配其中包括CC%的记录,注使用,分开的之中不是整个,前后可增加空格
如
AA,BB,DD
AA,BB,CC23434,FF
AA,BB,CC23434 ,FF
AA,BB,CC232
CC322
CC233,BB,DD
CC233 ,BB,DD
AA,BB,FFCC232,XX
CC,DD,FFCC434
BBCC结果为
AA,BB,CC23434,FF
AA,BB,CC23434 ,FF
AA,BB,CC232
CC322
CC233,BB,DD
CC233 ,BB,DD先谢谢大家了
如
AA,BB,DD
AA,BB,CC23434,FF
AA,BB,CC23434 ,FF
AA,BB,CC232
CC322
CC233,BB,DD
CC233 ,BB,DD
AA,BB,FFCC232,XX
CC,DD,FFCC434
BBCC结果为
AA,BB,CC23434,FF
AA,BB,CC23434 ,FF
AA,BB,CC232
CC322
CC233,BB,DD
CC233 ,BB,DD先谢谢大家了
select * from t where patindex('%,cc%',col)>0
select * from t where ','+col like ',cc%'
insert @T select'AA,BB,DD'
insert @T select'AA,BB,CC23434,FF'
insert @T select'AA,BB,CC23434 ,FF'
insert @T select'AA,BB,CC232'
insert @T select'CC322'
insert @T select'CC233,BB,DD'
insert @T select'CC233 ,BB,DD'
insert @T select'AA,BB,FFCC232,XX'
insert @T select'CC,DD,FFCC434'
insert @T select'BBCC'select * from @t where ','+col like '%,cc%' select * from @t where patindex('%,cc%',','+col)>0
go
declare @T table(col nvarchar(50))
insert @T select'AA,BB,DD'
insert @T select'AA,BB,CC23434,FF'
insert @T select'AA,BB,CC23434 ,FF'
insert @T select'AA,BB,CC232'
insert @T select'CC322'
insert @T select'CC233,BB,DD'
insert @T select'CC233 ,BB,DD'
insert @T select'AA,BB,FFCC232,XX'
insert @T select'CC,DD,FFCC434'
insert @T select'BBCC'select * from @t where ','+col like '%,cc[^,]%' select * from @t where patindex('%,cc[^,]%',','+col)>0col
--------------------------------------------------
AA,BB,CC23434,FF
AA,BB,CC23434 ,FF
AA,BB,CC232
CC322
CC233,BB,DD
CC233 ,BB,DD(所影响的行数为 6 行)col
--------------------------------------------------
AA,BB,CC23434,FF
AA,BB,CC23434 ,FF
AA,BB,CC232
CC322
CC233,BB,DD
CC233 ,BB,DD(所影响的行数为 6 行)
AA,BB, CC232 ,XX谢谢了
insert @t select'AA,BB,DD'
insert @t select'AA,BB,CC23434,FF'
insert @t select'AA,BB,CC23434 ,FF'
insert @t select'AA,BB,CC232'
insert @t select'CC233,BB,DD'
insert @t select'CC233 ,BB,DD'
insert @t select'AA,BB,FFCC232,XX'
insert @t select'CC,DD,FFCC434'
insert @t select'BBCC'
----------------
insert @T select'CC' select * from @T where ','+col like '%,CC%' and ','+col+',' not like '%,CC,%'
/*
col
--------------------------------------------------
AA,BB,CC23434,FF
AA,BB,CC23434 ,FF
AA,BB,CC232
CC233,BB,DD
CC233 ,BB,DD(5 行受影响)
*/
AA,BB, CC232 ,XX 谢谢了
---------------------
,cc--这个条件已经满足了
roy_88应当也没有问题可是
,cc好象不能配到AA,BB, CC232 ,XX 条记录我
没有测试