Home Forums General Issues SQL query for my article (custom fields) Reply To: SQL query for my article (custom fields)

  • 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';


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