【SQL】WordPressの更新日を最新にする

更新日を最新にする

UPDATE `wp_posts` SET `post_modified` = CURRENT_TIMESTAMP, `post_modified_gmt` = UTC_TIMESTAMP WHERE `wp_posts`.`post_status` = 'publish' AND `wp_posts`.`post_type` = 'post';

UPDATE `wp_posts` SET `post_modified` = CURRENT_TIMESTAMP, `post_modified_gmt` = UTC_TIMESTAMP WHERE `wp_posts`.`post_status` = 'publish' AND `wp_posts`.`post_type` = 'page';

投稿日を最新にする

UPDATE `wp_posts` SET `post_date` = CURRENT_TIMESTAMP, `post_date_gmt` = UTC_TIMESTAMP WHERE `wp_posts`.`post_status` = 'publish' AND `wp_posts`.`post_type` = 'post';

UPDATE `wp_posts` SET `post_date` = CURRENT_TIMESTAMP, `post_date_gmt` = UTC_TIMESTAMP WHERE `wp_posts`.`post_status` = 'publish' AND `wp_posts`.`post_type` = 'page';