Thread: Looking for a way to renew expired listings via phpmyadmin

Looking for a way to renew expired listings via phpmyadmin

Hi,
I have over 800 listings that have recently expired.
What columns in the database control the expiry date? I'd like to do a mysql update to the expired listings to republish them with a date set in 2019.

Here is the code I used, but the listings expired again shortly after...so I am guessing I need to make a change elsewhere:


UPDATE wp_posts SET post_modified = replace(post_modified, '2013-11-06', '2019-11-06');

UPDATE wp_posts SET post_modified_gmt = replace(post_modified_gmt, '2013-11-06', '2019-11-06');

UPDATE wp_posts SET post_status = replace(post_status, 'expired', 'publish');

Thanks!

Mass Renew All Expired Listing in Vantage