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