SQL: join two tables (LEFT OUTER JOIN) then update values

UPDATE wp_posts SET post_date = REPLACE (post_date, 'X', 'Y') ... Try this way, if you use SQL Server UPDATE WP SET WP.post_date ...

stackoverflow.com