SELECT SUBSTRING_REGEXPR('[^,]+' IN 'C515,GT-ShiWanGerWeiShenMer,A' FROM 1 OCCURRENCE 2) from dummy; 以逗号","作为截取标准,获取第2个字段,结果为"GT-ShiWanGerWeiShenMer",
SUBSTRING_REGEXPR Function (String) Searches a string for a regular expression pattern and returns one occurrence of the matching substring. Syntax SUBSTR[ING]_REGEXPR( <pattern> [ FLAG <flag> ] IN <regex_subject_string> [ FROM <start_position> ] [ ...