Need help trying to move data around

Hello
I am trying to do the following . I have 200 users in a table.For each user, in the plugin column are stored additionnal informations, in the format described below

{
"userExtendedFieldscontact":"contact"
"userExtendedFieldsaddress":"address",
"userExtendedFieldsaddress2":"",
"userExtendedFieldszipCode":"zipcode",
"userExtendedFieldscity":"city",
}

What i need to do is to split those in different columns, keeping only the values (data1, data2 etc ...)

So basically, what i'm trying to do is :
for each user extract contact and put it in userExtendedFieldscontact column
extract address and put it in userExtendedFieldsaddress column
extract address2 and put it in userExtendedFieldsaddress2 column
extract zipcode and put it in userExtendedFieldszipcode column
extract city and put it in userExtendedFieldcity column
columns already exist
I am trying to do it using the set instruction but i'am struggling to build the right mysql query to get the values. Help would be very much appreciated on this

tks !

 

Just curious...that looks like JSON data. Why not just use it from that table?

 

Hello
Sorry for the late answer, data is from a Joomla k2 plugin, it stores values in one field. I ve decided to create separate field for each value. I just need to move them to the right place now.

I want to give users the ability to mofidy the values and myself a way to export to excel

tks