Bulk modifying the publish time of a post is an important and useful feature in WordPress administration. Why do we need to modify the time? Batch modifying the post publishing time canOptimize the order of article content display, making the posting of a board post earlier or later.
![Image[1]-WordPress Bulk Modify Post Publishing Time - Photon Fluctuation | Professional WordPress repair service, worldwide, fast response](https://www.361sale.com/wp-content/uploads/2024/04/image-637.png)
First, let's go over a few time formats and field descriptions for when WordPress posts are saved in the database:
The post_date format of 0000-00-00 00:00:00 records the posting time of the article.
The post_date_gmt format is the same as above and records the standard time (GMT) when the post was published
post_modified is the post modification time
post_modified_gmt Post modification time (GMT)
Here we enter the actual operation, here we need to enter the WordPress database, generally we are practical phpadmin login, manage the database. First of all, first from the pagoda panel to phpmyadmin:
![Image[2]-WordPress Bulk Modify Post Publishing Time - Photon Flux | Professional WordPress repair service, worldwide, fast response](https://www.361sale.com/wp-content/uploads/2024/04/PixPin_2024-04-17_12-32-27.png)
1, phpmyadmin login
![Image[3]-WordPress Bulk Modify Post Publishing Time - Photon Flux | Professional WordPress repair service, worldwide, fast response](https://www.361sale.com/wp-content/uploads/2024/04/PixPin_2024-04-17_12-11-51.png)
2, select the name of the database you want to operate, that is, your WordPress station corresponding to the name of the database(The database name 123.com in this article is an example)
![Image[4]-WordPress Bulk Modify Post Publishing Time - Photon Flux | Professional WordPress repair service, worldwide, fast response](https://www.361sale.com/wp-content/uploads/2024/04/PixPin_2024-04-17_12-13-04.png)
3, select the SQL function in the current database
![Image[5]-WordPress Bulk Modify Post Publishing Time - Photon Volatility | Professional WordPress repair service, worldwide, fast response](https://www.361sale.com/wp-content/uploads/2024/04/PixPin_2024-04-17_12-13-40.png)
4, enter the sql statement and run the
![Image[6]-WordPress Bulk Modify Post Publishing Time - Photon Fluctuation | Professional WordPress repair service, worldwide, fast response](https://www.361sale.com/wp-content/uploads/2024/04/PixPin_2024-04-17_12-15-04.png)
Explanation of the sql statement in the above figure
UPDATE `wp_posts` SET `post_date` =DATE_ADD(`post_date`, INTERVAL 10 DAY) where post_type = 'post'UPDATE `wp_posts` SET `post_date` =DATE_ADD(`post_date`, INTERVAL 10 DAY) where post_type = 'post'UPDATE `wp_posts` SET `post_date` =DATE_ADD(`post_date`, INTERVAL 10 DAY) where post_type = 'post'
INTERVAL 10 DAY, that is, all the articles posting time increased by 10 days, such as 3 DAY (3 days), 5 HOUR (5 hours) 60 MIN (60 minutes), etc., you can modify according to the specific circumstances.
Above is to increase the time, of course, you can also reduce the time, such as posting time for April 10, I want to batch change to April 9 how to do, then modify the code above INTERVAL 10 DAY, changed to INTERVAL -1 DAY, that is, the negative 1 day, you can.
This is the basic method of WordPress batch modifying post time, mainly learning how to run sql code in phpmyadmin.
Link to this article:https://www.361sale.com/en/8110
The article is copyrighted and must be reproduced with attribution.
No comments