How can we split a string similar to below example based on delimiter ‘,’ in MySQL?
I want the splitted substrings into separate columns or rows. This can be easily done in SQL using
SPLIT_FUNCTION() but in MySQL there is no such function.
I have tried SUBSTRING_INDEX(). But it is giving only 1 substring based on delimiter index
Given input string:
‘Adam,John,Eve,Jack’
Expected output:
Column 1: Adam, Column 2: John, Column 3: Eve, Column 4: Jack
Or output in separate rows:
Adam
John
Eve
Jack