MySQL | RIGHT method
Start your free 7-days trial now!
MySQL's RIGHT(~) method returns a substring of len characters from the right of the input string.
Parameters
1. str | string
The input string from which to return the substring.
2. len | number
The number of characters to be returned in the substring.
If the provided number is greater than the length of the input string, the input string is returned.
Return value
A substring of len characters from the right of the input string.
Examples
Consider the following table about some students:
student_id | fname | lname | day_enrolled | age | username |
|---|---|---|---|---|---|
1 | Sky | Towner | 2015-12-03 | 17 | stowner1 |
2 | Ben | Davis | 2016-04-20 | 19 | bdavis2 |
3 | Travis | Apple | 2018-08-14 | 18 | tapple3 |
4 | Arthur | David | 2016-04-01 | 16 | adavid4 |
5 | Benjamin | Town | 2014-01-01 | 17 | btown5 |
The above sample table can be created using the code here.
Basic usage
To return the last three characters of students' last names:
SELECT lname, RIGHT(lname, 3)FROM students;
+--------+-----------------+| lname | RIGHT(lname, 3) |+--------+-----------------+| Towner | ner || Davis | vis || Apple | ple || David | vid || Town | own |+--------+-----------------+
To return the last two characters from 'Hello':
SELECT RIGHT('Hello', 2);
+-------------------+| RIGHT('Hello', 2) |+-------------------+| lo |+-------------------+
