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 LPAD() 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.

___ LPAD("SQL Tutorial",

3Order

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

The LPAD() function left-pads a string with another string, to a certain length.

Definition and Usage

MySQL LPAD() Function

Example

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

The LPAD() function left-pads a string with another string, to a certain length.

Note

Also look at the RPAD() function.

Syntax

LPAD(
string
,
 length
,
lpad_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 left-padded
lpad_string	Required. The string to left-pad to string

Works in:	From MySQL 4.0