RIGHT

RIGHT(s,n) allows you to extract n characters from the end of the string s.

 RIGHT('Hello world', 4) -> 'orld' 

SELECT name,
       RIGHT(name, 3)
  FROM bbc

• SUBSTRING function
• LEFT function
• POSITION function