LPAD() Function in MySQL

Last Updated : 21 Jun, 2021

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

Syntax :

LPAD(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 left padding.
padstr –
String that to be added to the left side of the Original Str.

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

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

SELECT LPAD("geeksforgeeks", 20, "*") AS LeftPaddedString;

Output :

LeftPaddedString
*******geeksforgeeks

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

SELECT LPAD("geeksforgeeks", 10, "*") AS LeftPaddedString;

Output :

LeftPaddedString
geeksforge

Example-3 : LPAD Function can also be used to add a string for column data. To demonstrate create a table named Student.

CREATE TABLE Student ( Student_id INT AUTO_INCREMENT,   Student_name VARCHAR(100) NOT NULL, Student_Class VARCHAR(20) NOT NULL, PRIMARY KEY(Student_id ) );

Now inserting some data to the Student table :

INSERT INTO Student (Student_name, Student_Class) VALUES ('Ananya Majumdar', 'IX'), ('Anushka Samanta', 'X'), ('Aniket Sharma', 'XI'), ('Anik Das', 'X'), ('Riya Jain', 'IX'), ('Tapan Samanta', 'X');

So, the Student Table is as follows.

Student_id	Student_name	Student_Class
1	Ananya Majumdar	IX
2	Anushka Samanta	X
3	Aniket Sharma	XI
4	Anik Das	X
5	Riya Jain	IX
6	Tapan Samanta	X

Now, we are going to add some string to every string presented in the Student_Class column.

SELECT Student_id, Student_name, LPAD(Student_Class, 10, ' _') AS LeftPaddedString FROM Student;

Output :

Student_id	Student_name	LeftPaddedString
1	Ananya Majumdar	_ _ _ _IX
2	Anushka Samanta	_ _ _ _ X
3	Aniket Sharma	_ _ _ _XI
4	Anik Das	_ _ _ _X
5	Riya Jain	_ _ _ _IX
6	Tapan Samanta	_ _ _ _ X

MID() function in MySQL

jana_sayantan

Improve

Article Tags :

Similar Reads

LN() Function in MySQL

LN() function : It is the function in MySQL is used to calculate the natural logarithm of a specific number with base e . The number must be greater than 0, otherwise it will return NULL. Syntax : LN(X) Parameter : LN() function accepts one parameter as mentioned above in the syntax and described be

2 min read

LEAST() Function in MySQL

The LEAST() function in MySQL is a versatile tool that returns the smallest (minimum) value from a list of expressions. It can be used with numbers, strings, or even columns of data to find the minimum value according to their data type. In this article, We will learn about LEAST() Function in MySQL

4 min read

MOD() Function in MySQL

The MOD() function in MySQL is used to find the remainder of one number divided by another. The MOD() function returns the remainder of dividend divided by divisor. if the divisor is zero, it returns NULL. Syntax: MOD(N, M) or N % M or N MOD M Parameter : MOD() function accepts two parameter as ment

4 min read

MID() function in MySQL

MID() : This function in MySQL is used to extract a substring from a given input string. If the starting position is a positive number, then the substring of the given length will be extracted from the starting index. If negative, then the substring of the given length will be extracted from the end

2 min read

LOG() Function in MySQL

LOG() function in MySQL is used to calculate the natural logarithm of a specific number. The number must be >0 Otherwise it will return NULL. Syntax : LOG(X) Parameter : This method accepts one parameter as mentioned above and described below : X : A number whose logarithm value we want to calcul

3 min read

LEFT() Function in MySQL

The LEFT() function in MySQL is used to extract a specified number of characters from the left side of a given string. It uses its second argument to decide, how many characters it should return. Syntax: LEFT (str, len)Parameter: This function accepts two parameters as mentioned above and described

1 min read

LOG2() Function in MySQL

In this article, we are going to cover the LOG2() function that means it will calculate the logarithm of a specific number with base 2. Pre-requisite :LOG function LOG2() function in MySQL is used to calculate the natural logarithm of a specific number with base 2. The number must be >0 Otherwise

2 min read

MySQL ISNULL( ) Function

The MySQL ISNULL() function is used for checking whether an expression is NULL or not. This function returns 1 if the expression passed is NULL; otherwise, it returns 0. The ISNULL() function in MySQL accepts the expression as a parameter and returns an integer with a value of a value 0 or 1 dependi

2 min read

LTRIM() Function in MySQL

LTRIM() : This function in MySQL is used to remove leading spaces from a string. Syntax : LTRIM(str) Parameter : It accepts one parameter as mentioned above and described below as follows. str â€“ The string from which we want to remove leading spaces. Returns : It returns a string after truncating al

2 min read

LOG10() Function in MySQL

LOG10() function in MySQL is used to calculate the natural logarithm of a specific number with base 10. The number must be greater than 0, otherwise it will return NULL. Syntax : LOG10(X) Parameter : This method accepts one parameter as mentioned above in the syntax and described below : X - A numbe

2 min read