samedi 2 mai 2015

SQL Syntax Error Message

I am trying to execute the following SQL queries on a database.

UPDATE wp_options SET option_value = replace(option_value, ‘http://yourdomain’, ‘http://your-elastic-ip’) WHERE option_name = ‘home’ OR option_name = ‘siteurl';

I replace "yourdomain" with my domain, and I replace "your-elastic-ip" with my IP address on Amazon Web Services. However, I keep getting an SQL syntax error. It says:

WHERE option_name = ‘home’ OR option_name = ‘siteurl';

#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 'WHERE option_name = ‘home’ OR option_name = ‘siteurl'' at line 1.

What am I doing wrong? Am I not understanding exactly what to put in the proper fields? What am I supposed to replace "home" and "siteurl" with?




Aucun commentaire:

Enregistrer un commentaire