select substr('1234',1,2) from dual;
oracle
select instr('1234545','4545',1,1) from dual;
mysql
select instr('1234545','4545') from dual;
select substr('1234',1,2) from dual;
oracle
select instr('1234545','4545',1,1) from dual;
mysql
select instr('1234545','4545') from dual;