MySQL RIGHT() Function

In this context, we will learn how we can use the MySQL RIGHT() Function with proper syntax and good examples.

Introduction of MySQL RIGHT() function

The RIGHT() function in MySQL is used to extract a specified number of characters from the right side of a given string. The second argument is used to decide how many characters it should return.

Syntax of the MySQL RIGHT() Function

The syntax of the MySQL RIGHT() function is given as follows:

RIGHT(str, len)

Parameters or arguments used in MySQL RIGHT() Function:

There are two parameters accepted by the RIGHT() Function in MySQL, which are given as follows:

Str: The given string from whose right side a number of characters are to be extracted.

Len: The number of characters to extract. If this parameter is larger than the number of characters in the string, this Function will return the actual string.

Returns:

It will return a number of characters from a string (starting from the right).

Application used for RIGHT() function:

The RIGHT() function can be used in the given below MySQL versions.:

• MySQL 5.7
• MySQL 5.6
• MySQL 5.5
• MySQL 5.1
• MySQL 5.0
• MySQL 4.1
• MySQL 4.0
• MySQL 3.23

Examples of MySQL RIGHT() function:

Now we will look into some MySQL RIGHT() function examples and will explore how we can use the RIGHT function in MySQL.

Example-1 :

In this example, we will Apply the RIGHT() Function to a given string in MySQL.

SELECT RIGHT("JAVATPOINT", 4) AS Right_Str;

Output:

Right_Str
OINT
1 row in set (0.00 sec)

Example 2:

In this example, we will Apply the RIGHT() Function to a given number in MySQL.

SELECT RIGHT(12345678, 4) AS Right_Num;

Output:

Right_Num
5678
1 row in set (0.00 sec)

Example-3:

In this example, we will Apply the RIGHT() Function to a given string in MySQL

when len > characters in the string.

SELECT RIGHT("JAVATPOINT", 20) AS Right_Str;

Output:

Right_Str
JAVATPOINT
1 row in set (0.00 sec)

Example-4 :

When we require to find the Last Name of the Cricketer in a table, then we can take the help of the RIGHT function in MySQL. To demonstrate, create a table named Cricketer.

CREATE TABLE Cricketer(
Cricketer_id INT AUTO_INCREMENT,
Cricketer_name VARCHAR(100) NOT NULL,
Playing_team VARCHAR(20) NOT NULL,
PRIMARY KEY(Cricketer_id )
);

Now, we will insert some data into the Cricketer table :

INSERT INTO
Cricketer(Cricketer_name, Playing_team)
VALUES
('Virat Kohli', 'RCB' ),
('Rohit Sharma', 'MI' ),
('Dinesh Karthik', 'KKR' ),
('Shreyash Iyer', 'DC' ),
('David Warner', 'SRH' ),
('Steve Smith', 'RR' ),
('Andre Russell', 'KKR' ),
('Jasprit Bumrah', 'MI' ),
('Risabh Panth', 'DC' ) ;

So, the Cricketer Table is :

mysql> SELECT * FROM Cricketer;

Cricketer_id	Cricketer_name	Playing_team
1	Virat Kohli	RCB
2	Rohit Sharma	MI
3	Dinesh Karthik	KKR
4	Shreyash Iyer	DC
5	David Warner	SRH
6	Steve Smith	RR
7	Andre Russell	KKR
8	Jasprit Bumrah	MI
9	Risabh Panth	DC

Now we will find the Last Name of every Cricketer, to find the last name, we have to apply the following approach-

First, use INSTR() Function to find the location of the space ( ) in the Name.

Secondly, we will use the LENGTH() Function to find the length of the Cricketer's Name. Here 'len' of the RIGHT Function will be the length of Cricketer_name minus the location of the ''(space) character.

Third, use the RIGHT( ) Function to extract the Last Name of the Cricketer.

SELECT
Cricketer_name,
RIGHT(Cricketer_name, LENGTH(Cricketer_name) - INSTR(Cricketer_name, ' ')) Lastname,
Playing_team
FROM
Cricketer;

Output:

Cricketer_name	Lastname	Playing_team
Virat Kohli	Kohli	RCB
Rohit Sharma	Sharma	MI
Dinesh Karthik	Karthik	KKR
Shreyash Iyer	Iyer	DC
David Warner	Warner	SRH
Steve Smith	Smith	RR
Andre Russell	Russell	KKR
Jasprit Bumrah	Bumrah	MI
Risabh Panth	Panth	DC

Application of MySQL RIGHT() function:

This Function is used to extract a specified number of characters from the right side of a given string.

Summary:

In the above context, we have learned how we can use the RIGHT() Function in MySQL used to extract a specified number of characters from the right side of a given string.