I run a blog where I post daily items based on the day in history (http://thisdayintechhistory.com). I like to refresh the posts for each day by updating the posts with the currently year so that the items for that day show up on top, plus the RSS feed is refreshed so that the items are sent out every day (plus posted to Facebook, etc.). I finally figured out a way to automate to process by running a cron job of a mysql command (instead of manually updating each post every day!). However, it seems that my mysql command does not trigger the Feedpress plugin to ping an update. I would like to know if there is a simple way to do this, or to schedule Feedpress to automatically update the feed.
Here is my mysql command for reference:
UPDATE wp_posts SET post_date_gmt = concat(UTC_DATE(),' ',time(post_date_gmt)), post_date = concat(CURDATE(),' ',time(post_date)), post_modified = NOW(), post_modified_gmt = UTC_TIMESTAMP() WHERE MONTH( post_date ) = MONTH( CURDATE( ) ) AND DAYOFMONTH( post_date ) = DAYOFMONTH( CURDATE( ) ) AND post_status = 'publish'