INSTR

Syntax

INSTR(str,substr)

Description

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.

INSTR() performs a case-insensitive search.

If any argument is NULL, returns NULL.

Examples

SELECT INSTR('foobarbar', 'bar'); +---------------------------+ | INSTR('foobarbar', 'bar') | +---------------------------+ | 4 | +---------------------------+  SELECT INSTR('My', 'Maria'); +----------------------+ | INSTR('My', 'Maria') | +----------------------+ | 0 | +----------------------+

See Also

• LOCATE() ; Returns the position of a string within a string

• SUBSTRING_INDEX() ; Returns the substring from string before count occurrences of a delimiter

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}