Syntax:
SUBSTRING(string,position[,length]) SUBSTRING(string FROM position[FOR length])
Description: Returns the portion of string starting at position characters from the left. If length is specified, no more than length characters will be returned.
Examples:
SUBSTRING('Howard Jacobs' FROM 4) returns ard Jacobs.
SUBSTRING('Howard Jacobs' FROM 4 FOR 2) returns ar.
SUBSTRING('Howard Jacobs',4,2) returns ar.
See also: LEFT(), MID(), RIGHT(), SUBSTRING_INDEX()
18.224.54.136