INSTR(str,substr)

Returns the position of the first occurrence of substring substr in string str. This is the same as the two-argument form of LOCATE(), except that the order of the arguments is reversed.

Syntax

MYSQL Copy

SELECT INSTR('foobarbar', 'bar');
4
SELECT INSTR('xbar', 'foobar');
0

Examples

Example

This function is multibyte safe, and is case-sensitive only if at least one argument is a binary string. If either argument is NULL, this functions returns NULL.

MYSQL Copy

SELECT INSTR('foobarbar', 'bar');
4
SELECT INSTR('xbar', 'foobar');
0