#2 SPLIT function !?

[Dan Bolser]

It would be really great if you could add a split
function to the UDF's.

The split would generate one row per 'chunk' of data split.

For example

1) Example data

select * from T1;
x y
a 1
a 2
a 3
b 1
b 2
b 3

2) Show existing function

create T2 select x, group_concat(y,":") as z from T1;

select * from T2
x z
a 1:2:3
b 1:2:3

3) How new function should work

select x, split(z, ":") as y_again from T2;

x y_again
a 1
a 2
a 3
b 1
b 2
b 3

This would be really cool (and not too hard?)

Please make this UDF, and please integrate with MySQL
more :) I love what you do!

[Dan Bolser]

Logged In: YES
user_id=810134

Does anybody maintain this project any more?

Seems we need a central MySQL UDF page.

Here is one attempt...

http://empyrean.lib.ndsu.nodak.edu/~nem/mysql/udf/

This project would seem the ideal place to host a
centralised effort, but nobody seems to be here...