Expand description
MySQL-compatible LOCATE function implementation.
LOCATE(substr, str) - Returns the position of the first occurrence of substr in str (1-based). LOCATE(substr, str, pos) - Returns the position of the first occurrence of substr in str, starting from position pos. Returns 0 if substr is not found.
Structsยง
- Locate
Function - MySQL-compatible LOCATE function.
Constantsยง
- NAME ๐
Functionsยง
- cast_
to_ ๐int64 - cast_
to_ ๐large_ utf8 - Cast array to LargeUtf8 for uniform string access.
- locate_
substr ๐ - Find the 1-based position of needle in haystack, starting from start_pos (0-based character index). Returns 0 if not found.