UPDATE wp_posts SET post_content = REPLACE(post_content, 'http://rosmid.ru/', '/') WHERE post_content LIKE '%http://rosmid.ru/%' UPDATE b_iblock_element SET CODE = REPLACE(CODE, '.', '_') WHERE CODE LIKE '%.%'