SQL copy post_title to post_content

Question

frank roburough

2020年10月8日 00:54

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

Category Web

Alexander Holsgrove · Accepted Answer · 2020年10月8日 00:54

Alexander Holsgrove answered at 2020年10月8日 00:54

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

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