MariaDB: LPAD Function
This MariaDB tutorial explains how to use the MariaDB LPAD function with syntax and examples.
Description
The MariaDB LPAD function returns a string that is left-padded with a specified string to a certain length.
Syntax
The syntax for the LPAD function in MariaDB is:
LPAD( string, length, pad_string )
Parameters or Arguments
- string
- The string to left-pad.
- length
- The length of the result after string has been left-padded.
- pad_string
- The specified string to left-pad to string.
Note
- If string is longer than length, the LPAD function will remove characters from string to shorten it to length characters.
- See also the RPAD function.
Applies To
The LPAD function can be used in the following versions of MariaDB:
- MariaDB 10
Example
Let's look at some MariaDB LPAD function examples and explore how to use the LPAD function in MariaDB.
For example:
SELECT LPAD('TechOnTheNet.com', 20, 'A'); Result: 'AAAATechOnTheNet.com' SELECT LPAD('TechOnTheNet.com', 20, 'ABC'); Result: 'ABCATechOnTheNet.com' SELECT LPAD('TechOnTheNet.com', 21, 'ABC'); Result: 'ABCABTechOnTheNet.com' SELECT LPAD('TechOnTheNet.com', 4, 'ABC'); Result: 'Tech' SELECT LPAD('totn', 8, ' '); Result: ' totn' SELECT LPAD('totn', 6, '123'); Result: '12totn' SELECT LPAD('totn', 7, '123'); Result: '123totn'
Advertisements