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