背景:直接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 '?'