INSTR

Returns the first position of the given search string.

Syntax

INSTR (str, searchstr)

Arguments

Info

This function is identical to LOCATE but with the arguments reversed.

Return Type

Integer position, one-indexed. 0 if not found.

Examples

memsql> select instr('ohai', 'i');
+--------------------+
| instr('ohai', 'i') |
+--------------------+
|                  4 |
+--------------------+

memsql> select instr('ohai', 'z');
+--------------------+
| instr('ohai', 'z') |
+--------------------+
|                  0 |
+--------------------+
Was this article useful?