LEFT(str,len)

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

Syntax

MYSQL Copy

SELECT LEFT('foobarbar', 5);
'fooba'

Examples

Example

This function is multibyte safe.

MYSQL Copy

SELECT LEFT('foobarbar', 5);
'fooba'