Skip to main content

INSTR

Description​

Returns the first occurrence position of substr in str (counting starts from 1). Special cases:

  • If substr does not appear in str, returns 0.

Syntax​

INSTR ( <str> , <substr> )

Parameters​

ParameterDescription
<str>String to search for
<substr>String to be searched for

Return value​

Parameters The first occurrence position of <substr> in <str> (counting starts from 1). Special cases:

  • If <substr> does not appear in <str>, returns 0.

Example​

SELECT INSTR("abc", "b"),INSTR("abc", "d")
+-------------------+-------------------+
| instr('abc', 'b') | instr('abc', 'd') |
+-------------------+-------------------+
| 2 | 0 |
+-------------------+-------------------+