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.
Thanks!
Leave an answer