You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

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

memsql> select left("1234567", 3);
+- -------------------+
| left("1234567", 3) |
+- -------------------+
| 123                |
+- -------------------+

Related Topics