RIGHT(str,len): Returns the rightmost len characters from the string str, or NULL if any argument is NULL : RIGHT « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. RIGHT
mysql>
mysql> SELECT RIGHT('ABCDEFGHIJK', 4);
+-------------------------+
| RIGHT('ABCDEFGHIJK', 4) |
+-------------------------+
| HIJK                    |
+-------------------------+
1 row in set (0.02 sec)

mysql>








23.35.RIGHT
23.35.1.RIGHT(str,len): Returns the rightmost len characters from the string str, or NULL if any argument is NULL
23.35.2.Get the 3 letters to the right of the first name