指定时间范围批量随机修改WordPress文章发布时间

MySql数据库SQL命令指定时间范围批量随机修改WordPress文章发布时间

UPDATE `wp_posts` SET `post_date` = DATE_ADD('2023-11-06 11:58:16', INTERVAL ROUND(RAND() * 365 + 1) DAY)  WHERE `ID` between 4 AND 1456897;
update `wp_posts` set `post_modified` = `post_date` WHERE `ID` between 1454275 AND 1456897;
update `wp_posts` set `post_date_gmt` = `post_date` WHERE `ID` between 1454275 AND 1456897;
update `wp_posts` set `post_modified_gmt` = `post_modified` WHERE `ID` between 1454275 AND 1456897;
update `wp_posts` set `post_status` = 'future' WHERE `ID` between 1454275 AND 1456897;

UPDATE `wp_posts` SET `post_date` = DATE_ADD('2023-11-06 11:58:16', INTERVAL ROUND(RAND() * 365 + 1) DAY) WHERE `ID` between 4 AND 1456897;

update `wp_posts` set `post_modified` = `post_date` WHERE `ID` between 1454275 AND 1456897;

update `wp_posts` set `post_date_gmt` = `post_date` WHERE `ID` between 1454275 AND 1456897;

update `wp_posts` set `post_modified_gmt` = `post_modified` WHERE `ID` between 1454275 AND 1456897;

update `wp_posts` set `post_status` = 'future' WHERE `ID` between 1454275 AND 1456897;

说明，ROUND(RAND() * 365 这里的365就是一年的日期，可以随机设置

post_status 可以设置定时发布future，也可以设置已经发布publish