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.
Returns the first position of the given search string.
LOCATE (needle, haystack)
LOCATE (needle, haystack, startpos)
Integer position, one-indexed. 0 if not found.
+---------------------+
| LOCATE('i', 'ohai') |
+---------------------+
| 4 |
+---------------------+
SELECT LOCATE('z', 'ohai');
+---------------------+
| LOCATE('z', 'ohai') |
+---------------------+
| 0 |
+---------------------+
SELECT LOCATE('i', 'ohaiohai', 6);
+----------------------------+
| LOCATE('i', 'ohaiohai', 6) |
+----------------------------+
| 8 |
+----------------------------+