SQL> select * from test;
ID
------------------------------------------------------------
c_zhang
zhangsan
cccccc
SQL> select id from test where id like 'c_%' escape '';
ID
------------------------------------------------------------
c_zhang
SQL> select id from test where id like 'c=_%' escape '=';
ID
------------------------------------------------------------
c_zhang
SQL> select id from test where id like 'c/_%' escape '/';
ID
------------------------------------------------------------
c_zhang