Outdated Version

You are viewing an older version of this section. View current production version.

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