SQL> insert into test(a) values ('''sdf''');1 row created.Elapsed: 00:00:00.00 SQL> commit;Commit complete.Elapsed: 00:00:00.02 SQL> select * from test;A ---------- 'sdf'Elapsed: 00:00:00.01 SQL> select * from test where a like '%''%';A ---------- 'sdf'Elapsed: 00:00:00.01 SQL> select * from test where a like '''%';A ---------- 'sdf'Elapsed: 00:00:00.01楼主最好自己试验完再说别人的结果正确与否
SELECT * FROM test WHERE name LIKE '%''%' oracle 中就这样
两个引号就可以转义过来了
SQL> commit;Commit complete.Elapsed: 00:00:00.02
SQL> select * from test;A
----------
'sdf'Elapsed: 00:00:00.01
SQL> select * from test where a like '%''%';A
----------
'sdf'Elapsed: 00:00:00.01
SQL> select * from test where a like '''%';A
----------
'sdf'Elapsed: 00:00:00.01楼主最好自己试验完再说别人的结果正确与否
oracle 中就这样