27,580
社区成员
发帖
与我相关
我的任务
分享
DECLARE @T TABLE (COL VARCHAR(10))
INSERT @T SELECT 'ADAD/SALE'
INSERT @T SELECT 'AAD'
SELECT * FROM @T WHERE COL LIKE'%/SALE%'
SELECT * FROM @T WHERE COL LIKE'%[/]SALE%'
/*COL
----------
ADAD/SALE
COL
----------
ADAD/SALE
*/
selec 改为 select
create table #temp([str] varchar(100))
insert into #temp select '@#$#/sale'
select * from #temp
select * from #temp where [str] like '%/sale%'
/*
@#$#/sale
*/
能查出来呀。
要不你改为:
selec * from table where col like '%[/]sale%'