勤与奋
专注国外LEAD联盟

wordpress随机批量修改文章发布日期

UPDATE `wp_posts` SET `post_date` = DATE_ADD(‘2019-1-01’, INTERVAL ROUND(RAND() * 544+ 1) DAY) WHERE `ID` between 1 AND 453;
update `wp_posts` set `post_modified` = `post_date` WHERE `ID` between 1 AND 453;
update `wp_posts` set `post_date_gmt` = `post_date` WHERE `ID` between 1 AND 453;
update `wp_posts` set `post_modified_gmt` = `post_modified` WHERE `ID` between 1 AND 453;
update `wp_posts` set `post_status` = ‘publish’ WHERE `ID` between 1 AND 453;

在数据库执行sql语句,2019-1-01这个是起始日期,在544天内随机 ,1 AND 453 这个是数据库中的wp内容id,在1到453中间将日期随机,wp_posts是表名,如前缀修改,需要把wp修改成你所设置的前缀

赞(0)
未经允许不得转载:勤与奋国外LEAD联盟 » wordpress随机批量修改文章发布日期
分享到: 更多 (0)