Mariadb Mid Function
MariaDB: MID Function
This MariaDB tutorial explains how to use the MariaDB MID function with syntax and examples.
Description
The MariaDB MID function allows you to extract a substring from a string.
Syntax
The syntax for the MID function in MariaDB is:
MID( string, start_position, length )Parameters or Arguments
- string
- start_position
- length
The source string.
The position for extraction. The first position in the string is always 1.
The number of characters to extract.
Note
- The first position in string is 1.
- If start_position is a positive number, then the MID function starts from the beginning of the string.
- If start_position is a negative number, then the MID function starts from the end of the string and counts backwards.
- The MID function and the SUBSTR function are synonyms of the SUBSTRING function.
Applies To
The MID function can be used in the following versions of MariaDB:
- MariaDB 10
Example
Let's look at some MariaDB MID function examples and explore how to use the MID function in MariaDB.
For example:
SELECT MID('AODBA.com', 1, 4);
Output: 'AODB'
SELECT MID('AODBA.com', 5, 8);
Output: 'A.com'
SELECT MID('AODBA.com', -3, 3);
Output: 'com'