SQL error - no delimiter between...

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

SQL error - no delimiter between...

Postby aronkallay » 28. December 2016 01:14

I am trying to run the following SQL query in phpMyAdmin:

UPDATE wp_options SET option_value = replace(option_value, 'http://www.example.com', 'http://localhost/test-site') WHERE option_name = 'home' OR option_name = 'siteurl';

When I paste or type this in, I get the little red "X" with several errors when I hover over. They are:

a new statement was found, but no delimiter between it and the previous one (near replace)
unexpected token (near ()
several more unexpected tokens...

This is a database I've imported from an existing site. I've searched around for this error, but cannot find it anywhere.

Any help would be much appreciated.

Thanks.
aronkallay
 
Posts: 1
Joined: 28. December 2016 01:07
XAMPP version: 5.6.28
Operating System: Os X 10.10.5

Return to XAMPP for macOS

Who is online

Users browsing this forum: No registered users and 111 guests