I would like to update all post’s modified date to be current date via mysql for my wordpress site
Simply run the following mysql query
*dont forget replace wordpress prefix
update wp_posts set post_post_modified = NOW(), post_post_modified_gmt= NOW() where post_type = 'post'