split

split

Description

この関数は、与えられた文字列をセパレータに従って分割し、分割された部分をARRAYで返します。

Syntax

ARRAY<VARCHAR> split(VARCHAR content, VARCHAR delimiter)

Examples

mysql> select split("a,b,c",",");
+---------------------+
| split('a,b,c', ',') |
+---------------------+
| ["a","b","c"]       |
+---------------------+

mysql> select split("a,b,c",",b,");
+-----------------------+
| split('a,b,c', ',b,') |
+-----------------------+
| ["a","c"]             |
+-----------------------+

mysql> select split("abc","");
+------------------+
| split('abc', '') |
+------------------+
| ["a","b","c"]    |
+------------------+

keyword

SPLIT