Batch modifying the posting time of an article inWordPressIt is an important and useful feature in management. Why modify the time? Batch modification of article 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 article 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 to learn how to run sql code in phpmyadmin.