SQL/MySQL/Function/INSTR

Use INSTR

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

*/  
select INSTR("123456","56");