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 |
+---------------+