Skip to content
Advertisement

Cant update table wp_options for wordpress in mariadb

Im trying to update wp_options table with a new url and the command just wont work.

UPDATE TABLE wp_options 
SET option_value = "http://34.66.147.230" 
WHERE option_name = "siteurl";

“You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘TABLE wp_options SET option_value = “http://34.66.147.230″ WHERE option_n ame …’ at line 1”

Advertisement

Answer

you don”t need ‘table’ keyword and use single-quote for string values:

UPDATE wp_options 
SET option_value = 'http://34.66.147.230' 
WHERE option_name = 'siteurl';
User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement