MariaDB: SUBSTRING_INDEX Function
This MariaDB tutorial explains how to use the MariaDB SUBSTRING_INDEX function with syntax and examples.
Description
The MariaDB SUBSTRING_INDEX function returns the substring of string before number of occurrences of delimiter.
Syntax
The syntax for the SUBSTRING_INDEX function in MariaDB is:
SUBSTRING_INDEX( string, delimiter, number )
Parameters or Arguments
- string
- The source string.
- delimiter
- The delimiter to search for in string.
- number
- The number of times to search for delimiter.
Note
- If number is a negative value, everything from the left of the targeted delimiter is returned by the SUBSTRING_INDEX function.
- If number is a positive value, everything from the right of the targeted delimiter is returned by the SUBSTRING_INDEX function.
- See also SUBSTRING function.
Applies To
The SUBSTRING_INDEX function can be used in the following versions of MariaDB:
- MariaDB 10
Example
Let's look at some MariaDB SUBSTRING_INDEX function examples and explore how to use the SUBSTRING_INDEX function in MariaDB.
For example:
SELECT SUBSTRING_INDEX('www.checkyourmath.com', '.', 1); Result: 'www' SELECT SUBSTRING_INDEX('www.checkyourmath.com', '.', 2); Result: 'www.checkyourmath' SELECT SUBSTRING_INDEX('www.checkyourmath.com', '.', -1); Result: 'com' SELECT SUBSTRING_INDEX('www.checkyourmath.com', '.', -2); Result: 'checkyourmath.com'
Advertisements