0

I have this example of a table in MySQL

x        y

1        a, b, c
2        b, d, f

How do I extract each item in the y column into its own row?

I'm looking for something like this table below for example

x        y

1        a
1        b
1        c
2        b
2        d
2        f

Thanks!

0 Answers0