I know this is the off topic (sorry), but it is a php project that I'm working on! I need some pointers on how to pivot a mysql column (containing comma delimited data) into an equal number of rows (see example). Any direction (pointers to links, etc. would be appreciated).
>From this: user.table uid|name|groups 1|mcgiddin|1,4,7,10,12 To this: pivot.table uid|group 1|1 1|4 1|7 1|10 1|12