使用SQL命令批量更改WordPress文章发布时间

如果需要把采集的文章批量修改一下时间，你可以使用如下SQL代码进行操作。  

UPDATE wp_posts SET post_date = DATE_ADD('2014-1-01', INTERVAL ROUND(RAND() * 500 + 1) DAY) WHERE ID between 6297 AND 14332;

update wp_posts set post_modified = post_date WHERE ID between 6297 AND 14332;

update wp_posts set post_date_gmt = post_date WHERE ID between 6297 AND 14332;

update wp_posts set post_modified_gmt = post_modified WHERE ID between 6297 AND 14332;

update wp_posts set post_status = 'publish' WHERE ID between 6297 AND 14332;

注意事项 1、起始时间自己更改一下。'2019-1-01' 2、然后就是控制随机生成在那个日期段。500 3、文章的起始ID和结束ID。6297 AND 14332