How to pad a string at the right end using the RPAD() function?

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:

• LPAD() - Left-Padding String

⇒ RTRIM() - Right-Trimming String

⇐ RIGHT() - Last N Characters

⇑ MySQL Functions on Character String Values

⇑⇑ MySQL Function References