Skip to main content
Skip to main content

INSTR

instr​

Description​

Syntax​

INSTR (VARCHAR STR, VARCHAR substrate)

Returns the location where substr first appeared in str (counting from 1). If substr does not appear in str, return 0.

example​

mysql> select instr("abc", "b");
+-------------------+
| instr('abc', 'b') |
+-------------------+
| 2 |
+-------------------+

mysql> select instr("abc", "d");
+-------------------+
| instr('abc', 'd') |
+-------------------+
| 0 |
+-------------------+

keywords​

INSTR