Articles/SQL

LEFT() in MySQL — How It Works

What the MySQL LEFT() function does, with an example.

Published October 18, 2026

LEFT() returns a specified number of characters from the start (left side) of a string.

Key points

  • Part of standard SQL functions available in MySQL for working with text/strings

Example

SELECT LEFT('Hello World', 5);  -- 'Hello'
More SQL articles