I want to add custom field 'tnid' to all my posts, and have it's meta value taken from field 'name'
i have the following working query:
INSERT INTO wp_postmeta (post_id, meta_key, meta_value)( SELECT post_id, 'tnid', meta_value FROM wp_postmeta WHERE meta_key='name')
Now to my question. I want to add the new custom field only to post_type 'post', not to any other post_type. How do i have to edit the SQL query to accomplish that? thx