Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

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 |
+--------------------+