SingleStore DB

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

Notice

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