SQL> select * from test;
ID NAME
---------- --------------------
1 baaab
2 ba_ab
3 ba%ab
SQL> select * from test where name like '%_%';
ID NAME
---------- --------------------
1 baaab
2 ba_ab
3 ba%ab
SQL> select * from test where name like '%\_%' escape '\';
ID NAME
---------- --------------------
2 ba_ab
oracle查询通配符做普通字符使用
最新推荐文章于 2021-04-09 22:25:52 发布