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 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
SELECT INSTR('ohai', 'i');
+--------------------+
| INSTR('ohai', 'i') |
+--------------------+
| 4 |
+--------------------+
sELECT INSTR('ohai', 'z');
+--------------------+
| INSTR('ohai', 'z') |
+--------------------+
| 0 |
+--------------------+
