How to mysql Update table field with JSON data from Serialized data field??

Question

Hi there,

Here's my situation: - a table with a varchar field in which i store serialized data from php

• now I have to add another field to the mysql table in which i store JSON data also from php

As the table already has serialized data stored i was wondering if i can unserialize > json_encode and store the data in the new db field??

Or is this not directly possible in mysql and i have to use php??

regards,