MySQL Function Reference

LEFT

Returns the specified number of leftmost characters of the string

MySQL 8.1

LEFT(str, number_of_characters)

str

Source string

number_of_characters

The number of characters to extract

Examples

MySQL 8.1

SELECT LEFT('sql-academy', 3);