You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

INSTR

Returns the first position of the given search string.

Syntax

INSTR (str, searchstr)

Arguments

  • str: any string or binary object
  • searchstr: string to search for
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 |
+--------------------+