Complete content
Web_id

To: web_ctime random changes for such as 2014 - month - day - 2020 - month - day can be random, for help

CodePudding user response:

Refer to the MySql database SQL commands specify a time range in bulk modify WordPress post time but time format is not the same, don't understand.
The UPDATE ` wp_posts ` SET ` post_date `=DATE_ADD (' 2014-1-01 ', the INTERVAL ROUND (RAND () * 500 + 1) DAY WHERE ` ID ` between 6297 AND 14332;

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

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

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

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