[RESOLVED] What MySQL function would pull the first x number of letters?

[conjurer]

I am blanking out and don't know where to find it...what string function do you use in MySQL query to pull the first x number of letters of a string value?

[conjurer]

Bingo!
LEFT(str,len)

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

mysql> SELECT LEFT('foobarbar', 5);
-> 'fooba'