Return the leftmost characters. This function returns the specified number of characters from the beginning (left) of a string.
SELECT LEFT('MariaDB', 5);
+--------------------+
| LEFT('MariaDB', 5) |
+--------------------+
| Maria |
+--------------------+