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