/* mysql> select INSTR('123456','56'); +----------------------+ | INSTR('123456','56') | +----------------------+ | 5 | +----------------------+ 1 row in set (0.00 sec) */ select INSTR('123456','56');