Reply To: SQL query for my article (custom fields)

• pecnet

• August 7, 2016 at 9:06 pm

Hello,

I looked at your link
but I did not understand
or I have to put the custom fields

And I found this query but it does not work

INSERT INTO wp_postmeta (post_id, meta_key, meta_value) SELECT wp_posts.ID, 'my-custom-field', 0 FROM wp_posts WHERE wp_posts.post_status = 'publish' AND wp_posts.post_type='hello';

-> https://snippets.khromov.se/batch-adding-custom-field-to-posts/

I am looking for a query that can add custom fields and make all update to post

thanks