MySQL has a couple of functions for extracting a substring from a string. They differ in how the substring is selected -- in one of them you specify a delimiter string, and in t'other you specify the index of the first character you want.
The one in which you specify an index is called Substring(). The one in which instead of an index you specify a delimiter is called ... wait for it ... Substring_Index(). Wow. Smylers
