rivkamak
asked on
mysql throwing syntax error
I am trying to update my wordpress table and this query string which look fine to me is throwing a syntax error.
Is there something I'm missing.
UPDATE `wp_options` SET `option_value` = replace(`option_value`, "http://www.denverkollel.org/site", "http://www.denverkollel.org") WHERE `option_name` = 'home' OR `option_name` = 'siteurl';
Is there something I'm missing.
UPDATE `wp_options` SET `option_value` = replace(`option_value`, "http://www.denverkollel.org/site", "http://www.denverkollel.org") WHERE `option_name` = 'home' OR `option_name` = 'siteurl';
ASKER
Sorry, that didn't help the problem
And what error are you getting?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes. And the manual says it acts like INSERT. I don't think it should be used where it is in the original post.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window