MySQL LEFT() Function

❮ MySQL Functions

Example

Extract 3 characters from a string (starting from left):

SELECT LEFT("SQL Tutorial", 3) AS ExtractString;

Try it Yourself »

---

Definition and Usage

The LEFT() function extracts a number of characters from a string (starting from left).

Tip: Also look at the RIGHT() function.

Syntax

LEFT(string, number_of_chars)

Resource:https://www.w3schools.com/sql/func_mysql_left.asp