I used SUBSTRING_INDEX again to grab the 2nd item from the right, but now I get more data than I want, I need another tool for this
It is time to look at LOCATE and LENGTH