Remove article expiration date multiple articles

[hittolo1]

Hello
i have around 400 article published but expired. How can i remote that and re - publish all article?
Thanks

[imanickam]

If you want to re-publish all the articles, you could make use of SQL to accomplish what you want.

The following SQL would re-publish all the articles. xyz_ is the database/table prefix for your site.

Code: Select all

UPDATE `xyz_content` SET `publish_down` = NULL;

This could be accomplished using tools such as phpMyAdmin.

If needed, you could add WHERE clause to the SQL statement if only certain rows that meet specific criteria are to be affected.

Note:
(a) Test this in a development/test environment before making changes to the production site's database.
(b) Be aware that this SQL does not update the publish date of the articles. The date of publishing is stored in the column publich_up.