admin管理员组

文章数量:1320637

Anyone know the SQL to copy post_title to post_content where post_content is empty for all and only posts in wordpress

Thanks for any pointers in advance Richard

Anyone know the SQL to copy post_title to post_content where post_content is empty for all and only posts in wordpress

Thanks for any pointers in advance Richard

Share Improve this question asked May 13, 2019 at 12:52 frank roburoughfrank roburough 32 bronze badges
Add a comment  | 

1 Answer 1

Reset to default 0

This isn't really about WordPress, however you want:

UPDATE wp_posts SET post_content = post_title WHERE post_content= "" AND post_type = 'post';

本文标签: mssqlSQL copy posttitle to postcontent