SQL query to move content from tabs to custom fields? [closed]


Can anyone help me to create a SQL query?

I have custom product tabs created Woocommerce Tab Manager. I need to move the content from two different tabs to two new fields created with Advanced Custom Fields. I need to do this for 150 products, so I don’t think manual cut and paste is viable.

The meta_key I find in the wp_postmeta table in the DB is _product_tab_content.
However, it contains the content for both tabs, and I can’t see how they are separated.

If I look at the wp_posts entry, I see the content for just the one tab.

How will I go about creating a query to copy content from these tabs into ACF fields?

I realise more info might be needed, but I could do with some guidance to get this info.


, , RexTheRunt 3 years 2020-03-27T08:51:29-05:00 0 Answers 94 views 0

Leave an answer