CREATE TABLE test (info VARCHAR(50))
GO
INSERT INTO test
VALUES ('[web.]maomao365.com'),(web.maomao365.com)
GO

select * from test where info like %[web.]%'
---输出2行数据，like条件中[]被界定为包含

SELECT FROM test 
WHERE info LIKE  %\[address.]%' 
-采用斜杠类似转义，但是转义失败，返回空数据行
go
LIKE %$[web.]%' ESCAPE $'


%@[web.]%@-采用escape 定义 @ $为以上sql脚本的转义字符

go

drop table test