Collections:
LPAD() - Left-Padding String
How to pad a string at the left end using the LPAD() function?
✍: FYIcenter.com
LPAD(str, len, padstr) is a MySQL built-in function that truncates a string or pad it at the left end to a given length. For example:
SET @str = 'ops'; SELECT LPAD(@str, 6, 'o'); -- +--------------------+ -- | LPAD(@str, 6, 'o') | -- +--------------------+ -- | oooops | -- +--------------------+
Reference information of the LPAD() function:
LPAD(str, len, padstr): modstr Returns the string str, left-padded with the string padstr to a length of len characters. If str is longer than len, the return value is shortened to len characters. It returns NULL if any of its arguments are NULL. Arguments, return value and availability: str: Required. The string that will be searched in. len: Required. The number of characters to be truncated or left-padded to. padstr: Required. The substring to pad with. modstr: Return value. The modified string after truncating or padding. Available since MySQL 4.0.
Related MySQL functions:
⇒ LTRIM() - Left-Trimming String
⇐ LOWER() - Convert String to Lower Case
2023-11-12, 223🔥, 0💬
Popular Posts:
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...