转义字符:
要求一:查出vname中包含字符串“CED”的行
SQL> select * from v where vname like '%CED%';
VNAME
-------
ABCEDF
_BCEDF
_\BCEDF
要求二:查出vname中包含字符串“_BCE”的行
SQL> SELECT * FROM v WHERE vname LIKE '_BCE%';
VNAME
-------
ABCEDF
_BCEFG
_BCEDF
多了ABCEDF
% 替代一个或多个字符
_ 仅替代一个字符
SQL> SELECT * FROM v WHERE vname LIKE '\_BCE%' escape '\';
VNAME
-------
_BCEFG
_BCEDF
要求三:查找_\BCEDF的行
SQL> SELECT * FROM v WHERE vname LIKE '\_\\BCE%' escape '\';
VNAME
-------
_\BCEDF
转载于:https://www.cnblogs.com/zhaoyangjian724/p/3797874.html