escape - 将特殊符号解释为普通字符 将 ‘\’ 后的特殊符号转为普通字符(我们习惯用 ‘\’,当然你用其他的也行 ) WITH t_test AS ( SELECT 'a_123' a FROM dual UNION ALL SELECT 'ab_123' a FROM dual ) SELECT * FROM t_test t WHERE t.a LIKE 'a\_%' ESCAPE '\'; 输出结果: 提示: _:任意一个字符%:任意多个字符