Cacher is the code snippet organizer for pro developers

// Поиск и замена:

UPDATE `wp_posts` 
SET `post_content` = REPLACE( 
  `post_content`,
  'src="/img/instructions.svg', 
  'src="/img/icons/instructions.svg'
) WHERE `post_content` LIKE '%src="/img/instructions.svg%'


// Удаление ревизий постов:

DELETE FROM wp_postmeta 
WHERE post_id IN (
    SELECT ID 
    FROM wp_posts 
    WHERE post_type = 'revision' 
    AND post_name LIKE '%revision%'
);

// Получить артикулы всех вариаций
SELECT `meta_value` FROM `wp_postmeta` WHERE `meta_key` = "_sku" AND `meta_value` != 0