SUBSTR

SUBSTR allows you to extract part of a string.

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

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