Syntax
INSTR(str,substr)
Purpose
INSTR() returns the position of the first occurrence of a substring in str. It is the same as the LOCATE() function with two parameters, unless the parameter sequence is reversed.
Examples
obclient> SELECT INSTR('foobarbar', 'bar'), INSTR('xbar', 'foobar');
+---------------------------+-------------------------+
| INSTR('foobarbar', 'bar') | INSTR('xbar', 'foobar') |
+---------------------------+-------------------------+
| 4 | 0 |
+---------------------------+-------------------------+
1 row in set