kakarotto-chen

oracle/dm：_ 英文下劃線讓like查詢失效的解決方案：ESCAPE關(guān)鍵字

 -- 可以查詢出帶（\）的值
 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 '\'