All Questions
1 question
9
votes
5
answers
12k
views
SQL (Maria DB) split string separated by comma to rows
I have this column:
names
John, Mary
Joseph
Eleanor, Sophia, Dani
And I want this output:
names
John
Mary
Joseph
Eleanor
Sophia
Dani
And it should include the SUBSTRING_INDEX function