Collections:
RPAD() - Right-Padding String
How to pad a string at the right end using the RPAD() function?
✍: FYIcenter.com
RPAD(str, len, padstr) is a MySQL built-in function that truncates a string or pad it at the right end to a given length. For example:
SET @str = 'yahoo'; SELECT RPAD(@str, 8, 'o'); -- +--------------------+ -- | RPAD(@str, 8, 'o') | -- +--------------------+ -- | yahooooo | -- +--------------------+
Reference information of the RPAD() function:
RPAD(str, len, padstr): modstr Returns the string str, right-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 right-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:
⇒ RTRIM() - Right-Trimming String
2023-11-12, 223🔥, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...