Oracle、达梦：_ 英文下划线 让LIKE查询失效的解决方案：ESCAPE关键字

oracle/dm：_ 英文下划线让like查询失效的解决方案：ESCAPE关键字

 -- 可以查询出带（\）的值
 SELECT 
 "f1","f2" 
FROM 
 "t1" 
 WHERE "f1" LIKE '%\\%' ESCAPE '\'
 
-- 可以查询出带（_）的值
 SELECT 
 "f1","f2" 
FROM 
 "t1" 
 WHERE "f1" LIKE '%\_%' ESCAPE '\'
 
 -- 可以查询出带（\_）的值
 SELECT 
 "f1","f2" 
FROM 
 "t1" 
 WHERE "f1" LIKE '%\\\_%' ESCAPE '\'