SQL> select * from tt2;
A B
-------- ----------
aaa2% 111
bbb3% 222
ccc0% 333
cccab 556
dd3f 8898
aaks 8899
6 rows selected.
SQL> select * from tt2
2 where a like '%3\%%' escape '\';
A B
-------- ----------
bbb3% 222
A B
-------- ----------
aaa2% 111
bbb3% 222
ccc0% 333
cccab 556
dd3f 8898
aaks 8899
6 rows selected.
SQL> select * from tt2
2 where a like '%3\%%' escape '\';
A B
-------- ----------
bbb3% 222
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
