SUBSTRING

SUBSTRING allows you to extract part of a string.

 SUBSTRING('Hello world', 2, 3) -> 'llo' 

SELECT name,
       SUBSTRING(name, 2, 5)
  FROM bbc