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