The LEFT function extracts a specified number of characters from the beginning of a string, while the MID function extracts a specified number of characters from any position in a string.