Add custom field to all posts in specific post_type

Question

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

Answer 1

Hope this below SQL query will solve your problem-

INSERT INTO wp_postmeta 
            (post_id, 
             meta_key, 
             meta_value) 
(SELECT post_id, 
        'tnid', 
        meta_value 
 FROM   wp_postmeta 
 WHERE  meta_key = 'name' 
        AND post_id IN (SELECT id 
                        FROM   wp_posts 
                        WHERE  post_type LIKE 'post'))

Please try it first. I haven't got the chance to try it.