Mass Edit WordPress Permilinks in Mysql (Find & Replace)

I am trying to edit permilinks in mysql. I ran a find and replace for the blog description which worked perfect but am coming up with an 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 ‘/%monthnum%/%day%/%postname%/’,’/%category%/%postname%/’)’ at line 1”

Here is the query I’m running:

update wp_85_options set option_value = replace(option_value,’/%year%/%monthnum%/%day%/%postname%/’,’/%category%/%postname%/’);

Read more here: Mass Edit WordPress Permilinks in Mysql (Find & Replace)

Leave a Reply

Your email address will not be published. Required fields are marked *