LPAD
On this page
Pads the beginning of a string up to the specified character length.
Syntax
LPAD (str, len, padding)
Arguments
-
str: any string or binary object
-
len: total length of the string
-
padding: the characters to pad with
Return Type
String
Examples
SELECT LPAD('ohai',10,'_') as o;
+------------+
| o |
+------------+
| ______ohai |
+------------+SELECT LPAD('123',10,'0') as o;
+------------+
| o |
+------------+
| 0000000123 |
+------------+Related Topics
Caution
Implicit Collation
When character_ is set to utf8, string literals with characters using 4-byte encoding are implicitly assigned binary collation and processed as a sequence of bytes rather than characters.utf8mb4 character set.
For more information, refer to Implicit Collation in Special Cases.
Last modified: March 22, 2024