[RESOLVED] Moved articles, need to change urls in database

[jwgrafflin]

I've tried several querys in an attempt to change the urls of my articles stored in my database. So far, none have worked. Here's an example:

UPDATE `articles`
SET 'url' LIKE '%http://www.newsite.com/library%'
WHERE `url` LIKE '%http://www.old-site.com/articles%'

[NogDog]

How about....

UPDATE `articles`
SET `url` = REPLACE(`url`, 'http://www.old-site.com/articles', 'http://www.newsite.com/library')

[jwgrafflin]

Thanks NogDog. Here's the final solution:

UPDATE articles SET  url = replace(url, 'http://www.old-site.com/articles', 'http://www.newsite.com/library')

For reference, see http://www.sqlteam.com/article/using...date-statement