This is MySQL User Defined Function written by cgo.
Split from string to json array.
| arg | explain |
|---|---|
| arg1 | pattern regexp pattern string |
| arg2 | subject base string |
$ ./build.sh (notice)
- require root privilege
(simple)
MariaDB [(none)]> select json_detailed(ws_split(',', 'aa,bb,cc')) as array; +----------------------------------+ | array | +----------------------------------+ | [ "aa", "bb", "cc" ] | +----------------------------------+ (pattern)
MariaDB [(none)]> select json_detailed(ws_split('[\\s,]+', 'hypertext language, programming')) as array; +--------------------------------------------------------+ | array | +--------------------------------------------------------+ | [ "hypertext", "language", "programming" ] | +--------------------------------------------------------+