随机批量修改wordpress文章发布时间mysql语句

都知道wordpress有个定时发布的功能，这下就给很多靠采集或不想天天发文章的懒人带来了福音。

先上mysql语句, 建议在phpmyadmin里运行！先别着急用，看懂了再用哦….

UPDATE `wp_posts` SET `post_date` = DATE_ADD('2018-01-21 06:08:08', INTERVAL ROUND(RAND() * 300 + 1) DAY)  WHERE `ID` between 379 AND 1491;
update `wp_posts` set `post_modified` = `post_date` WHERE `ID` between 379 AND 1491;
update `wp_posts` set `post_date_gmt` = `post_date` WHERE `ID` between 379 AND 1491;
update `wp_posts` set `post_modified_gmt` = `post_modified` WHERE `ID` between 379 AND 1491;
update `wp_posts` set `post_status` = 'future' WHERE `ID` between 379 AND 1491;

UPDATE `wp_posts` SET `post_date` = DATE_ADD('2018-01-21 06:08:08', INTERVAL ROUND(RAND() * 300 + 1) DAY) WHERE `ID` between 379 AND 1491;

update `wp_posts` set `post_modified` = `post_date` WHERE `ID` between 379 AND 1491;

update `wp_posts` set `post_date_gmt` = `post_date` WHERE `ID` between 379 AND 1491;

update `wp_posts` set `post_modified_gmt` = `post_modified` WHERE `ID` between 379 AND 1491;

update `wp_posts` set `post_status` = 'future' WHERE `ID` between 379 AND 1491;

上面的（2018-01-21 06:08:08）就是发布文章时间，其实意思是从2018-01-21这个日期开始往上加天数，随机加，加多少呢就是后面的300数字之内的，你可以自己设置。
上面还有个（between 379 AND 1491）表示，你wordpress里的文章ID数区间。
下面有个“post_status” 自己选；意思 “future”：保存为草稿。”publish”：立即发布。”pending”：待审核。

看懂了吧，实在看不懂，自己亲自去试；很多事情就不应看太懂！