LEFT

Return the leftmost characters. This function returns the specified number of characters from the beginning (left) of a string.

Syntax

LEFT(str,len)

Description

Returns the leftmost len characters from the string str, or NULL if any argument is NULL.

Examples

SELECT LEFT('MariaDB', 5);
+--------------------+
| LEFT('MariaDB', 5) |
+--------------------+
| Maria              |
+--------------------+

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}