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 !
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