SingleStore Managed Service

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                |
+- -------------------+