RPAD(str,len,padstr): Right pad str with the string padstr to a length of len characters : RPAD « String Functions « MySQL Tutorial

1. MySQL Tutorial
2. String Functions
3. RPAD

If str is longer than len, the return value is shortened to len characters.

mysql> SELECT RPAD('A',1,'?');
+-----------------+
| RPAD('A',1,'?') |
+-----------------+
| A               |
+-----------------+
1 row in set (0.00 sec)

mysql>