rpad
Description
This function returns strings with a length of len
(starting counting from the first syllable) in str
. If len
is longer than str
, the return value is lengthened to len
characters by adding pad characters behind str
. If str
is longer than len
, the return value is shortened to len
characters. len
means the length of characters, not bytes.
Syntax
VARCHAR rpad(VARCHAR str, INT len[, VARCHAR pad])
Parameters
str
: required, the string to be padded, which must evaluate to a VARCHAR value.
len
: required, the length of return value, it means the length of characters, not bytes, which must evaluate to an INT value.
pad
: optional, the characters to be added behind str, which must be a VARCHAR value. If this parameter is not specified, spaces are added by default.
Return value
Returns a VARCHAR value.
Examples
MySQL > SELECT rpad("hi", 5, "xy");
+---------------------+
| rpad('hi', 5, 'xy') |
+---------------------+
| hixyx |
+---------------------+
MySQL > SELECT rpad("hi", 1, "xy");
+---------------------+
| rpad('hi', 1, 'xy') |
+---------------------+
| h |
+---------------------+
MySQL > SELECT rpad("hi", 5);
+---------------------+
| rpad('hi', 5, ' ') |
+---------------------+
| hi |
+---------------------+
keyword
RPAD