摘要: ESCAPE只作用于它前面的转义字符,不是全局的,如果有多个需要转义,就要添加多个ESCAPESELECT * 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(&# 阅读全文
posted @ 2012-12-21 16:07 嗨,你的益达~~~ 阅读(165) 评论(0) 推荐(0) 编辑