MySQL RIGHT Function: Extract String Characters

The RIGHT function in MySQL is used to return a specified number of characters from the right side of a string. Its syntax is as follows:

Extracts a specified number of characters from the right side of a string.

In this case, ‘str’ is the string to be trimmed, and ‘len’ is the number of characters to be returned.

For example, you can use the following statement to retrieve the last 5 characters of the string “Hello World”:

Choose the last 5 characters of the string “Hello World”.

The result is “World”.