MYSQL query to change wordpress post title in bulk

Following MYSQL query used to change wordpress posts title in bulk. Below query needs to be executed in phpmyadmin after taking backup. Replace "-black friday deal' with your own text
UPDATE wp_posts set post_title = concat(post_title,'- black friday deal') WHERE post_status='draft' and post_content <> '';
Please take backup before running this query
Sign In or Register to comment.