Product Solutions Support
Try MemSQL

INSTR

Returns the first position of the given search string.

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?