请教高手,在SQL里面和LIKE变量反过来的怎么写?
比如:select * from lb_aa where user like 'kk'
我想查:select * from lb_aa where 'kk' like user
该怎么写啊····
请赐教··谢谢··
比如:select * from lb_aa where user like 'kk'
我想查:select * from lb_aa where 'kk' like user
该怎么写啊····
请赐教··谢谢··
insert into @tb select 'abcd'select * from @tb where name like '%c%'select * from @tb where charindex('c',name)>0
--这样?
select * from lb_aa where charindex(user,'kk')>0
INSERT @t SELECT 'aabbcc'
UNION ALL SELECT 'kkdd'
UNION ALL SELECT 'asdf'
SELECT * FROM @t WHERE CHARINDEX('kk',v)>0
SELECT * FROM @t WHERE PATINDEX('%kk%',v)>0
SELECT * FROM @t WHERE REPLACE(v,'kk','')!=v
select * from lb_aa where user like '%kk%'
select * from lb_aa where user like '%kk%' select * from lb_aa where charindex('kk',user)>0select * from lb_aa where patindex('%kk%',user)>0
select * from lb_aa where 'kk' like '%'+user+'%'