MySQL LEFT Function
Example Extract 3 characters from a string (starting from left): SELECT LEFT(“SQL Tutorial”, 3) AS ExtractString; Definition and Usage The LEFT() function extracts a number of characters from a string (starting from left). Tip: Also look at the RIGHT() function.