SUBSTR

SUBSTR(string,m[,n])

Returns a substring of a string, beginning at position m for n characters.

• If you specify m=0, the whole string is returned
• If you specify a negative number, the function returns the number of characters specified from the end of the string
• If you don't specify n, the default is to return all characters starting from m