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 (haystack, needle)
Arguments
- haystack: any string or binary object
- needle: 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 |
+--------------------+
