SELECT SUBSTRING_REGEXPR('[^,]+' IN 'C515,GT-ShiWanGerWeiShenMer,A' FROM 1 OCCURRENCE 2) from dummy;
以逗号","作为截取标准，获取第2个字段，结果为"GT-ShiWanGerWeiShenMer",
