WordPress Bulk Modify Post Publishing Time

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.

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:

1, phpmyadmin login

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)

3, select the SQL function in the current database

4, enter the sql statement and run the

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'

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.

Contact Us
Can't read the tutorial? Contact us for a free answer! Free help for personal, small business sites!	Customer Service
① Tel: 020-2206-9892
② QQ咨询：1025174874
(iii) E-mail: [email protected]
④ Working hours: Monday to Friday, 9:30-18:30, holidays off