关于like的问题

[jianjian51]

selec * from table where col like '%/sale%'
为什么col含有'/sale'数据查不出来

[xlsdan]

select * from a where name like '%/sale%'

你写错了 select

[水族杰纶]

--TRY
selec * from table  where col like '%[/]sale%' 

[jia_guijun]

晕~~

[水族杰纶]

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
*/

[you_tube]

DECLARE @tab TABLE 
(
id INT ,NAME VARCHAR(300)
)

INSERT INTO @tab 
SELECT 1,'a/col' UNION ALL 
SELECT 2,'dk'

SELECT  * from @tab  where NAME like '%/co%' 

/*
id          NAME
----------- -----------------------------
1           a/col

(1 行受影响)
*/