Syntax
INSTR(str,substr)
Purpose
You can call this function to return 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 (0.00 sec)