SQL> select * from a;
A
----------
aaa
aaa_
aaa_bbb
aaabbb
SQL> select a from a where a like '%_%';
A
----------
aaa
aaa_
aaa_bbb
aaabbb
SQL> select a from a where a like '%\_%' escape('\');
A
----------
aaa_
aaa_bbb
其中escape('\')的\可以用其他字符代替,如*,/等。
A
----------
aaa
aaa_
aaa_bbb
aaabbb
SQL> select a from a where a like '%_%';
A
----------
aaa
aaa_
aaa_bbb
aaabbb
SQL> select a from a where a like '%\_%' escape('\');
A
----------
aaa_
aaa_bbb
其中escape('\')的\可以用其他字符代替,如*,/等。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22745099/viewspace-625768/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22745099/viewspace-625768/