sql update column 2 with column 1 data

Question

Wordpress has 2 columns in its *wp_posts* table

• post_date (the actual date post was published)
• post_modified (the last time the post was modified)

I want to update/change/replace post_modified values with the values of post_date but haven't a clue how to except knowing I need a sql query.

Answer 1

Update wp_posts
set w1.post_modified = w2.post_date
from wp_posts w1, wp_posts w2 
where w1.IdCol = w2.IdCol

Answer 2

Maybe something like this:

UPDATE wp_posts
SET post_modified= post_date