Prepend code to the_content via MySQL
-
I have a custom field called: _format_video_embed
i want the value of this field that is a youtube link added to the start of the posts that i have. There are over 1400 posts that does not have the video link in the post_content but in the post_meta field called _format_video_embed
Is there a way to add this via MySQL?
Some update command that could work?
SELECT wposts.ID, wposts.post_title, wposts.post_content,wposts.post_type, wpostmeta.* FROM wp_posts wposts, wp_postmeta wpostmeta WHERE wposts.ID = wpostmeta.post_id AND wpostmeta.meta_key LIKE '_format_video_embed' AND wposts.post_type = 'post' ORDER BY wposts.ID DESC
That selects all the fields i need. Now i need to insert the meta value into the post_content. as the first line.
Can anyone help me with that?
Or some code to add to my functions.php that copies that field?
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
- The topic ‘Prepend code to the_content via MySQL’ is closed to new replies.