create table TT ( [name] varchar(30) ) insert into TT select '文本s' insert into TT select '文本s''' insert into TT select '文本sddadada' insert into TT select '121文本sddadada'declare @sql varchar(20) set @sql='文本s''' select * from TT where [name] like '%'+@sql+'%'
字符串“文本's”如果是从页面文本域keyName获取来,那是不是一定要对keyName进行处理,然后 select * from Tabale where [key_name] like '%'+keyName+'%'
--or
charindex('AA文本''s',字段)>0
select * from tb where 内容 like '%AA文本''s%'
(
[name] varchar(30)
)
insert into TT select '文本s'
insert into TT select '文本s'''
insert into TT select '文本sddadada'
insert into TT select '121文本sddadada'select * from TT where [name] like '%文本s''%'name
------------------------------
文本s'
(
[name] varchar(30)
)
insert into TT select '文本s'
insert into TT select '文本s'''
insert into TT select '文本sddadada'
insert into TT select '121文本sddadada'declare @sql varchar(20)
set @sql='文本s'''
select * from TT where [name] like '%'+@sql+'%'
select * from Tabale where [key_name] like '%'+keyName+'%'