Forum Discussion

santhiya's avatar
santhiya
Icon for Helper I rankHelper I
3 years ago

Extract data in serialized column to new column

Hi Community!!! I am having a column named "changes " and contains following value a:2:{s:4:"fruits";s:5:"Apple";s:4:"Flower";s:5:"Rose"}. I need to extract fruits and Flower as separate column wh...
Need Help
santhiya's avatar
santhiya
Icon for Helper I rankHelper I
3 years ago

Hi Ahmedx  Thanks for you time, This is not what i expect . The value should be extracted into new column with the key as column header 
eg: 
Fruit   Flower
Apple Rose 
Note: some time the key position may also change 



      Apple