I have a metabox for each post named post_info and the value of the metabox is as followed:
Size: 2Mb<br />Source: XYZ<br />Dimension: 800x800
Now I need to separate the value into 3 new metaboxes like this:
So the new format would be like this:
post_file_size -> 2Mb
post_file_source -> XYZ
post_file_dimension -> 800x800
As you can imagine the metabox value is always different for each post. And I have about 2000 posts, and doing this manually will probably take me about a hundred years.
Is there a SQL query that can do this?
Thank you in advance.