I'm trying to get a query to split comma-separated value's into one column in MySQL.
Example
Table1
name | professions
----- | -----------------------
James | writer,director,actor
Peter | writer,director,assistant,producer
And my result, Table2
name | professions
-------- | ------------
James | writer
James | director
James | actor
Peter | writer
Peter | director
Peter | assistant
Peter | producer
According to the first normal form (1nf)
Thanks
