SUBSTRING()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns a substring of the first argument given a character position and optional length.
USAGE
SUBSTRING(string, position[, length])
SUBSTRING(string FROM position[ FOR length])
Argument Name | Description |
|---|---|
| The source string |
| The numeric starting position |
| Optional. The numeric length |
DETAILS
SUBSTRING() is a string function that returns a substring of a string given a position within the string and an optional length limit.
The position argument is a 1-relative character count from the beginning of the string when positive, and a 1-relative character count from the end of the string when negative.
If the length argument is specified then the returned substring will contain at most length characters. When it is not specified, the length is not constrained and all remaining characters in the string are returned.
The arguments can be expressed in a SQL clause format using the FROM and FOR clauses instead of separating commas. The returned string is the same no matter how the position and length are specified.
A NULL is returned if any argument is NULL.
EXAMPLES
SELECT SUBSTRING('mariadb', 6) AS result1,
SUBSTRING('mariadb' FROM 5) as result2;
+---------+---------+
| result1 | result2 |
+---------+---------+
| db | adb |
+---------+---------+
SELECT SUBSTRING('mariadb', 1, 3) AS result1,
SUBSTRING('mariadb' FROM 2 FOR 3) AS result2;
+---------+---------+
| result1 | result2 |
+---------+---------+
| mar | ari |
+---------+---------+