RPAD() Function in MySQL

RPAD() function in MySQL is used to pad or add a string to the right side of the original string. 

Syntax : 
 

RPAD(str, len, padstr)

Parameter : This function accepts three parameter as mentioned above and described below : 
 

• str : The actual string which is to be padded. If the length of the original string is larger than the len parameter, this function removes the overfloating characters from string. 
  
   
• len : This is the length of a final string after the right padding. 
  
   
• padstr : String that to be added to the right side of the Original Str. 
   

Returns : It returns a new string of length len after padding. 

Example-1 : Applying RPAD() Function to a string to get a new padded string. 
 

SELECT RPAD("geeksforgeeks", 20, "*") AS RightPaddedString;

Output : 













 

Example-2 : Applying RPAD() Function to a string when the original string is larger than the len parameter. 
 

SELECT RPAD("geeksforgeeks", 10, "*") AS RightPaddedString;

Output : 













 

Example-3 : Applying RPAD() Function to a string column in a table : 

Table - Student_Details : 
































 

SELECT RPAD(Name, 15, "#") AS RightPadStudentName
FROM Student_Details;

Output : 






















 

jana_sayantan

Follow

Improve

Article Tags :

• DBMS
• SQL
• mysql