MSSQL LIKE模糊查询带关键字的数据

背景：直接like查询匹配不到数据

SELECT 1WHERE '["List":[]}]' LIKE '%[]%'

解决方案：

1.用方括号（[]）处理特殊字符

SELECT 1WHERE '["List":[]}]' LIKE '%[[]]%'

2.用转义符：escape

SELECT 1 WHERE '["List":[]}]' LIKE '%\[\]%' escape '\'
SELECT 1 WHERE '["List":[]}]' LIKE '%/[/]%' escape '/'
SELECT 1 WHERE '["List":[]}]' LIKE '%|[|]%' escape '|'
SELECT 1 WHERE '["List":[]}]' LIKE '%?[?]%' escape '?'