How to convert array into rows in mysql 5.7

Asked Jul 12 '21 at 16:34

Active Jul 13 '21 at 07:35

Viewed 181 times

i have a data in below format and length of array is dynamic:

col1                                                col2
['a@google.com','b@google.com','c@yahoo.com']  ['x@google.com','y@google.com','z@yahoo.com']

i want the data in this format:

col1             col2
a@google.com    x@google.com
a@google.com    y@google.com
a@google.com    z@yahoo.com
b@google.com    x@google.com
...              ....

data type of col1 and col2 is JSON

edited Jul 13 '21 at 07:35

asked Jul 12 '21 at 16:34

Swati Garg

How are `col1` and `col2` defined in the database? – Bob Jarvis - Слава Україні Jul 12 '21 at 16:48
they are defined as json datatype. – Swati Garg Jul 13 '21 at 03:53
What about https://stackoverflow.com/questions/39906435/convert-json-array-in-mysql-to-rows? – Nico Haase Jul 13 '21 at 07:39
Or this? https://stackoverflow.com/questions/38786080/mysql-and-json-transform-array-to-rows – Nico Haase Jul 13 '21 at 07:40
Or this? https://stackoverflow.com/questions/60249675/mysql-5-7-convert-simple-json-array-to-rows – Nico Haase Jul 13 '21 at 07:40

How to convert array into rows in mysql 5.7

0 Answers0