STRING_SPLIT

The string function used to split a string into multiple substrings, based on some delimiter. Unlike other functions, STRING_SPLIT returns multiple rows, one per substring.

Parameter	Type
`string_to_split`	string
`delimiter`	string

Returns: string

Example

query:

SELECT STRING_SPLIT("a,b,c", ",")

siyeh/sql-crm-example-data Run query Copy code

results:

string_split
a
b
c

The STRING_SPLIT function requires two arguments. The first argument is the string to be split and it can be stated either as a string or as a column. The second argument is the character to split the string on.