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:
Code:
UPDATE `articles`
SET 'url' LIKE '%http://www.newsite.com/library%'
WHERE `url` LIKE '%http://www.old-site.com/articles%'