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.

LEFT

Extracts the specified number of characters from the left end of a string

Syntax

LEFT(str, len)

Arguments

  • str: any string or binary object
  • len: the number of characters to be extracted

Return Type

String

Examples

SELECT LEFT("1234567", 3);
+- -------------------+
| LEFT("1234567", 3) |
+- -------------------+
| 123                |
+- -------------------+

Related Topics