没有问题的. SQL> select * from test_1;A -------------------- a%b ab a+b [df]Elapsed: 00:00:00.00查询包含‘+’的: SQL> select * from test_1 where a like '%+%';A -------------------- a+bElapsed: 00:00:00.01查询包含‘[’的: SQL> select * from test_1 where a like '%[%';A -------------------- [df]Elapsed: 00:00:00.00查询包含‘%’的: SQL> select * from test_1 where a like '%\%%' escape '\';A -------------------- a%bElapsed: 00:00:00.00 注意最后的转义关键词escape
SQL> select * from test_1;A
--------------------
a%b
ab
a+b
[df]Elapsed: 00:00:00.00查询包含‘+’的:
SQL> select * from test_1 where a like '%+%';A
--------------------
a+bElapsed: 00:00:00.01查询包含‘[’的:
SQL> select * from test_1 where a like '%[%';A
--------------------
[df]Elapsed: 00:00:00.00查询包含‘%’的:
SQL> select * from test_1 where a like '%\%%' escape '\';A
--------------------
a%bElapsed: 00:00:00.00
注意最后的转义关键词escape