Mega Code Archive

 

Categories / MySQL / Function

 

Use INSTR

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