SQL: replace Lightspeed Webshop URLs in WooCommerce Exported Products

gistfile1.txt

SELECT post_content,
REGEXP_REPLACE(post_content, 'https://static\\.webshopapp\\.com/shops/1234/files/[0-9]+/', 'https://new-url.com/fixed/path/')
FROM `db606006_1`.`eucph_posts`
WHERE 
post_content REGEXP 'https://static\\.webshopapp\\.com/shops/1234/[^\"\\s]*';



EXPLAIN UPDATE eucph_posts 
SET post_content = REGEXP_REPLACE(post_content, 'https://static\\.webshopapp\\.com/shops/1234/files/[0-9]+/', 'https://rechtwp.de/wp-content/uploads/2024/11/') 
WHERE post_content REGEXP 'https://static\\.webshopapp\\.com/shops/1234/[^\"\\s]*';