Change Posted Date in Bulk of Posts

  • I am trying to change the post date of some posts in bulk in phpmyadmin using the following:

    UPDATE wp_posts SET post_date = REPLACE (
post_date,
’2011-07-31′,
’2009-01-30′)

    But I keep getting this error:

    #1054 – Unknown column ‘a€?2011’ in ‘field list’

    How can I get this to work? Thanks.

  • The topic ‘Change Posted Date in Bulk of Posts’ is closed to new replies.