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

Filed under:
|
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

Related posts about sql

Related posts about mysql