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)


If you know the solution of this issue, please leave us a reply in Comment section, to update the question.

Wordpress related questions and answers: