You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

LOCATE

Returns the first position of the given search string.

Syntax

LOCATE (needle, haystack)
LOCATE (needle, haystack, startpos)

Arguments

  • needle: string to search for
  • haystack: any string or binary object
  • startpos: character position to start searching at
Info

This function is identical to INSTR but with the arguments reversed.

Return Type

Integer position, one-indexed. 0 if not found.

Examples

+---------------------+
| locate('i', 'ohai') |
+---------------------+
|                   4 |
+---------------------+

memsql> select locate('z', 'ohai');
+---------------------+
| locate('z', 'ohai') |
+---------------------+
|                   0 |
+---------------------+

memsql> select locate('i', 'ohaiohai', 6);
+----------------------------+
| locate('i', 'ohaiohai', 6) |
+----------------------------+
|                          8 |
+----------------------------+