Tag: mysql left function in where clause

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. Continue reading MySQL LEFT Function