RIGHT
On this page
Extracts the specified number of characters from the right end of a string
Syntax
RIGHT(str, len)
Arguments
-
str: any string or binary object
-
len: the number of characters to be extracted
Return Type
String
Examples
SELECT RIGHT("1234567", 3);
+---------------------+
| RIGHT("1234567", 3) |
+---------------------+
| 567 |
+---------------------+Caution
Implicit Collation
When character_ is set to utf8, string literals with characters using 4-byte encoding are implicitly assigned binary collation and processed as a sequence of bytes rather than characters.utf8mb4 character set.
Related Topics
Last modified: February 27, 2023