Outdated Version
You are viewing an older version of this section. View current production version.
SUBSTRING_INDEX
Extracts the portion of a string up to the given number of occurrences of a delimiter. This is mainly useful for delimited strings, eg a CSV or ascii table.
SUBSTRING_INDEX(str, delimiter, count)
Arguments
- str: any string or binary object
- delimiter: the ‘field’ delimiter
- count: the number of fields to extract
Return Type
String
Examples
memsql> select substring_index('a b c d', ' ', 3);
+------------------------------------+
| substring_index('a b c d', ' ', 3) |
+------------------------------------+
| a b c |
+------------------------------------+
memsql> select substring_index('de305d54-75b4-431b-adb2-eb6b9e546013', '-', 2) as uuid;
+---------------+
| uuid |
+---------------+
| de305d54-75b4 |
+---------------+
