mysql - mysql_query for update dates in WordPress database -

mysql - mysql_query for update dates in WordPress database -

can helps me should query(mysql_query) update dates(date=now) of post in specific category (ex. cat_id=164) in wordpress database?

select database query may be:

update wp_posts set post_date = now() exists (select null wp_term_relationships b b.object_id=a.id , b.term_taxonomy_id=164);

where 164 category id. if have other prefix wp_ in wp tables, alter your.

mysql database wordpress