SQL 转义

 ESCAPE只作用于它前面的转义字符，不是全局的，如果有多个需要转义，就要添加多个ESCAPE

SELECT * FROM MYTABLES t
                     WHERE 1 = 1         
                       AND (LOWER(USERNAME) LIKE
                           LOWER('%' || 'ZHANG\_' || '%')  ESCAPE '\' OR
                           LOWER(USERACCOUNT) LIKE LOWER('ZHANG\_' || '%')  ESCAPE '\' OR
                           LOWER(DEPART) LIKE LOWER('ZHANG\_' || '%')  ESCAPE '\' )                           
                          

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/qqzy168/p/2828146.html