Bugl — code interview practice that feels like a game

Loading lesson path

Flash cards

Review the key moves

1/4

Core idea

What is the main idea behind MySQL RPAD() Function?

Lesson checks

Short Mimo-style checks built from this lesson's code, terms, and sequence.

1Quick choice

Which statement best captures the main point of this lesson?

2Fill blank

Complete the missing token from the example code.

___ RPAD("SQL Tutorial",

3Order

Put the learning moves in the order that makes the concept easiest to apply.

The RPAD() function right-pads a string with another string, to a certain length.

Definition and Usage

MySQL RPAD() Function

Example

SELECT RPAD("SQL Tutorial",
  20, "ABC");

The RPAD() function right-pads a string with another string, to a certain length.

Note

Also look at the LPAD() function.

Syntax

RPAD(
string
,
 length
,
rpad_string
)

Parameter	Description
string	Required. The original string. If the length of the original string is larger than the length parameter, this function removes the overfloating characters from string
length	Required. The length of the string after it has been right-padded
rpad_string	Required. The string to right-pad to string

Works in:	From MySQL 4.0