1

I have a question. A created a custom field named video_desc. I have ofer 2000 posts and I need to add this custom field to all posts and add the text "Description Here" to it. How can this be done with SQL Query because all plugins I used didn't worked as it should. TThanks!

Improve this question

1 Answer 1

Reset to default
1

I manage to work my problem. For those who seek the same answer, just run this query

INSERT INTO wp_postmeta (post_id, meta_key, meta_value)
SELECT wp_posts.ID, 'video_desc', 'Description here'
FROM wp_posts
WHERE wp_posts.post_status = 'publish';
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.