How to Bulk Update/Edits WordPress Content, Post Titles, Meta

I’m going to bulk update all the WordPress post content, post titles, post meta via mysql.

Please make sure you have backed up your database before you do anything!

Bulk update/edit WordPress titles

UPDATE wp_posts
SET post_title = REPLACE( post_title, 'your-conten-there', 'new-conten-there' );

Bulk update/edit WordPress post date

update wp_posts
set post_date= replace(post_date, '2021-12', '2022-01') ;

Bulk update/edit WordPress Post Content

I’m going to update all my images’ urls from http to hppts

UPDATE wp_posts SET post_content = replace(post_content, ‘http://www.dobeweb.com/wp-content/uploads’,‘https://www.dobeweb.com/wp-content/uploads’);