Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Extracts the specified number of characters from the left end of a string
LEFT(str, len)
str
: any string or binary objectlen
: the number of characters to be extractedString
SELECT LEFT("1234567", 3);
+- -------------------+
| LEFT("1234567", 3) |
+- -------------------+
| 123 |
+- -------------------+