Hi Janis,
I am trying with your code. It brings me this error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''wp_posts'
SET post_date = "2015-07-22 23:50:30"
WHERE post_date BETWEEN '2015' at line 1
I am using:
UPDATE'wp_posts'
SET post_date="2015-07-22 20:31:30"
WHERE post_date BETWEEN '2015-07-31 00:00:00' AND '2015-12-14 00:00:00'
AND post_status="publish"
Any help would be appreciated. My SQL server version is 5.5.44
Thanks