Outdated Version

You are viewing an older version of this section. View current production version.

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

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

select instr('ohai', 'z');
+--------------------+
| instr('ohai', 'z') |
+--------------------+
|                  0 |
+--------------------+