LEFT

LEFT(s,n) allows you to extract n characters from the start of the string s.

 LEFT('Hello world', 4) -> 'Hell' 

SELECT name,
       LEFT(name, 3)
  FROM bbc

• SUBSTRING function
• RIGHT function
• POSITION function