SQL Reference
STR_SPLIT_REGEX
str_split_regex(string, regex, options)
Section titled “str_split_regex(string, regex, options)”- string: VARCHAR
- regex: VARCHAR
- options: VARCHAR
Example
Section titled “Example”SELECT str_split_regex('hello world; 42', ';? ');