SQL Function Reference

LEFT

Returns the specified number of leftmost characters of the string

MySQL

LEFT(str, number_of_characters)

str

Source string

number_of_characters

The number of characters to extract

Examples

MySQL

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