SUBSTRING_INDEX

​

Syntax

​

Scalar

substring_index(value, delimiter, count)

​

Arguments

​

Returns

• Type: STRING
• Possible values: The selected prefix or suffix.
• NULL behavior: Returns NULL for NULL arguments.

​

Properties

​

Usage notes

• Zero count or empty delimiter returns an empty string. If abs(count) exceeds the number of delimiter occurrences, returns the whole input.

​

Examples

​

Typical behavior

SELECT substring_index('www.apache.org', '.', 1) AS prefix, substring_index('www.apache.org', '.', -1) AS suffix;

​

Keep multiple delimiter-separated parts

SELECT substring_index('a.b.c.d', '.', 2) AS first_two, substring_index('a.b.c.d', '.', -2) AS last_two;

​

Limitations

• Use SUBSTRING_INDEX. SUBSTR_INDEX is not an established SQL alias.