MySQL Substring to Find a Character & Return Left. ... The MySQL "LEFT" function returns a specified number of characters from the beginning of a string. For example: LEFT(item, 10) ...