MySQL RIGHT() Function Explained

In MySQL, the RIGHT() function is used to return a specified number of characters from the right side of a string. Its purpose is to extract a portion of a string from the right side with a specific length.

The syntax of the function is as follows:

RIGHT(str, length)

In this case, str is the string to be sliced and length is the number of characters to be returned.

Here is an example:

If there is a table called users with a column named name storing users’ full names, you can use the RIGHT() function to extract the last name (last word) from the names in the name column.

SELECT RIGHT(name, LENGTH(name) - INSTR(REVERSE(name), ' ')) AS last_name
FROM users;

This query will return the surname of each user in the name field.

It is important to note that the RIGHT() function returns a portion of the right side of a string, not a timestamp or any other type of data.