MariaDB: SUBSTRING Function
This MariaDB tutorial explains how to use the MariaDB SUBSTRING function with syntax and examples.
Description
The MariaDB SUBSTRING function allows you to extract a substring from a string.
Syntax
The syntax for the SUBSTRING function in MariaDB is:
SUBSTRING( string, start_position, [ length ] )
OR
SUBSTRING( string FROM start_position [ FOR length ] )
Parameters or Arguments
- string
- The source string.
- start_position
- The position for extraction. The first position in the string is always 1.
- length
- Optional. It is the number of characters to extract. If this parameter is omitted, it will return the entire string.
Note
- The first position in string is 1.
- If start_position is a positive number, then the SUBSTRING function starts from the beginning of the string.
- If start_position is a negative number, then the SUBSTRING function starts from the end of the string and counts backwards.
- The SUBSTR function and the MID function are synonyms of the SUBSTRING function.
Applies To
The SUBSTRING function can be used in the following versions of MariaDB:
- MariaDB 10
Example
Let's look at some MariaDB SUBSTRING function examples and explore how to use the SUBSTRING function in MariaDB.
For example:
SELECT SUBSTRING('TechOnTheNet.com', 5); Result: 'OnTheNet.com' SELECT SUBSTRING('TechOnTheNet.com' FROM 5); Result: 'OnTheNet.com' SELECT SUBSTRING('TechOnTheNet.com', 5, 2); Result: 'On' SELECT SUBSTRING('TechOnTheNet.com' FROM 5 FOR 2); Result: 'Tech' SELECT SUBSTRING('TechOnTheNet.com', -7, 3); Result: 'Net' SELECT SUBSTRING('TechOnTheNet.com' FROM -7 FOR 3); Result: 'Net'
Advertisements