[RESOLVED] Newbie SQL query prolem

[dobsie]

I'm trying to move my not for profit wordpress blog from wp.com to my own domain. I found I couldn't move the images and there are lots, so it was suggested I run the following query:

UPDATE wp_posts SET post_content = replace(post_content, ‘OLD_DOMAIN.files.wordpress.com/’, ‘NEW_DOMAIN.com/wp-content/uploads/’);

but I am getting

#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 '.com/’, ‘NEW_DOMAIN.com/wp-content/uploads/’)' at line 1

I'm not at all sure where to start - I've checked domaine names etc.

Thanks to anyone who can help!

[bradgrafelman]

You've got curly quotes in that SQL query. MySQL (just like PHP) denotes strings using normal single quotes.

[dobsie]

Thank you - this worked perfectly.

Sorry for the delay in coming back, I've had computer problems :mad: