RPAD(str,len,padstr)

MySQL 8.4

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. If str, padstr, or len is NULL, the function returns NULL.

Syntax

MYSQL

SELECT RPAD('hi',5,'?');
'hi???'
SELECT RPAD('hi',1,'?');
'h'

Examples

Example

This function is multibyte safe.

MYSQL

SELECT RPAD('hi',5,'?');
'hi???'
SELECT RPAD('hi',1,'?');
'h'