Mariadb Substring Function

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('AODBA.com', 5);
Output: 'A.com'

SELECT SUBSTRING('AODBA.com' FROM 5);
Output: 'A.com'

SELECT SUBSTRING('AODBA.com', 5, 2);
Output: 'AO'

SELECT SUBSTRING('AODBA.com' FROM 5 FOR 2);
Output: 'AODB'

SELECT SUBSTRING('AODBA.com', -7, 3);
Output: 'com'

SELECT SUBSTRING('AODBA.com' FROM -7 FOR 3);
Output: 'com'