Loading lesson path
Concept visual
Start at both ends
Formula
Left - pad the string with "ABC", to a total length of 20:SELECT LPAD("SQL Tutorial",
20, "ABC");Formula
The LPAD() function left - pads a string with another string, to a certain length.Also look at the RPAD() function.
string, length, lpad_string )
Required. The original string. If the length of the original string is larger than the length parameter, this function removes the overfloating characters from string length
Formula
Required. The length of the string after it has been left - padded lpad_string
Required. The string to left - pad to stringFrom MySQL 4.0
Formula
Left - pad the text in "CustomerName" with "ABC", to a total length of 30:SELECT LPAD(CustomerName, 30, "ABC") AS LeftPadCustomerName
FROM Customers;❮ MySQL Functions