
UPDATE `was_sitecontent_article` 
SET permalink = REPLACE(permalink, ':', '%3A')
WHERE permalink LIKE '%:%'
  AND published = 1;
