What is wrong with this SQL syntax?
Posted
by Finbarr
on Stack Overflow
See other posts from Stack Overflow
or by Finbarr
Published on 2010-06-01T22:48:20Z
Indexed on
2010/06/01
22:53 UTC
Read the original article
Hit count: 166
UPDATE files
SET filepath = REPLACE(filepath, `sites/somedomain.com/files/`, `sites/someotherdomain.com/files/`);
I have a table called files with a field called filepath. MySQL returns this error: Unknown column 'sites/somedomain.com/files/' in 'field list'
© Stack Overflow or respective owner