MySQL RIGHT Function

In this tutorial, we will learn about MySQL RIGHT function with an example. The function returns the rightmost length of characters from the string.

Syntax

The general syntax of the function is as follows:

RIGHT(string,length)

Example

mysql> SELECT RIGHT(‘TestingDocs’,4);
+————————+
| RIGHT(‘TestingDocs’,4) |
+————————+
| Docs |
+————————+
1 row in set (0.00 sec)

 

—

MySQL Tutorials

MySQL Tutorials on this website:

https://www.testingdocs.com/mysql-tutorials-for-beginners/

For more information on MySQL Database:

https://www.mysql.com/