Query para pasar urls de imagenes de produccion a desarrollo:

Produccion a local

  UPDATE imagens
SET
  url = REPLACE(url, 'https://apinutrablis.bloque9.design', 'https://pide-facil.test'),
  scale = REPLACE(scale, 'https://apinutrablis.bloque9.design', 'https://pide-facil.test'),
  thumb = REPLACE(thumb, 'https://apinutrablis.bloque9.design', 'https://pide-facil.test'),
  thumb_xs = REPLACE(thumb_xs, 'https://apinutrablis.bloque9.design', 'https://pide-facil.test'),
  url_webp = REPLACE(url_webp, 'https://apinutrablis.bloque9.design', 'https://pide-facil.test'),
  scale_webp = REPLACE(scale_webp, 'https://apinutrablis.bloque9.design', 'https://pide-facil.test'),
  thumb_webp = REPLACE(thumb_webp, 'https://apinutrablis.bloque9.design', 'https://pide-facil.test'),
  thumb_xs_webp = REPLACE(thumb_xs_webp, 'https://apinutrablis.bloque9.design', 'https://pide-facil.test')
WHERE
  url LIKE 'https://apinutrablis.bloque9.design%'
  OR scale LIKE 'https://apinutrablis.bloque9.design%'
  OR thumb LIKE 'https://apinutrablis.bloque9.design%'
  OR thumb_xs LIKE 'https://apinutrablis.bloque9.design%'
  OR url_webp LIKE 'https://apinutrablis.bloque9.design%'
  OR scale_webp LIKE 'https://apinutrablis.bloque9.design%'
  OR thumb_webp LIKE 'https://apinutrablis.bloque9.design%'
  OR thumb_xs_webp LIKE 'https://apinutrablis.bloque9.design%';



Local a produccion

  UPDATE imagens
SET
  url = REPLACE(url, 'https://pide-facil.test', 'https://apinutrablis.bloque9.design'),
  scale = REPLACE(scale, 'https://pide-facil.test', 'https://apinutrablis.bloque9.design'),
  thumb = REPLACE(thumb, 'https://pide-facil.test', 'https://apinutrablis.bloque9.design'),
  thumb_xs = REPLACE(thumb_xs, 'https://pide-facil.test', 'https://apinutrablis.bloque9.design'),
  url_webp = REPLACE(url_webp, 'https://pide-facil.test', 'https://apinutrablis.bloque9.design'),
  scale_webp = REPLACE(scale_webp, 'https://pide-facil.test', 'https://apinutrablis.bloque9.design'),
  thumb_webp = REPLACE(thumb_webp, 'https://pide-facil.test', 'https://apinutrablis.bloque9.design'),
  thumb_xs_webp = REPLACE(thumb_xs_webp, 'https://pide-facil.test', 'https://apinutrablis.bloque9.design')
WHERE
  url LIKE 'https://pide-facil.test/%'
  OR scale LIKE 'https://pide-facil.test/%'
  OR thumb LIKE 'https://pide-facil.test/%'
  OR thumb_xs LIKE 'https://pide-facil.test/%'
  OR url_webp LIKE 'https://pide-facil.test/%'
  OR scale_webp LIKE 'https://pide-facil.test/%'
  OR thumb_webp LIKE 'https://pide-facil.test/%'
  OR thumb_xs_webp LIKE 'https://pide-facil.test/%';
  


/*PESCADORES*/
UPDATE imagens
SET
  url = REPLACE(url, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  scale = REPLACE(scale, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  thumb = REPLACE(thumb, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  thumb_xs = REPLACE(thumb_xs, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  url_webp = REPLACE(url_webp, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  scale_webp = REPLACE(scale_webp, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  thumb_webp = REPLACE(thumb_webp, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  thumb_xs_webp = REPLACE(thumb_xs_webp, 'http://pide-facil.test', 'https://api.pescadores.mx');

UPDATE banners
SET
  imagen = REPLACE(imagen, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  imagen_1920 = REPLACE(imagen_1920, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  imagen_1280 = REPLACE(imagen_1280, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  imagen_768 = REPLACE(imagen_768, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  imagen_frontal = REPLACE(imagen_frontal, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  imagen_frontal_768 = REPLACE(imagen_frontal_768, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  imagen_frontal_460 = REPLACE(imagen_frontal_460, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  imagen_frontal_avif = REPLACE(imagen_frontal_avif, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  imagen_frontal_768_avif = REPLACE(imagen_frontal_768_avif, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  imagen_frontal_460_avif = REPLACE(imagen_frontal_460_avif, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  imagen_avif = REPLACE(imagen_avif, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  imagen_1920_avif = REPLACE(imagen_1920_avif, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  imagen_1280_avif = REPLACE(imagen_1280_avif, 'http://pide-facil.test', 'https://api.pescadores.mx'),
  imagen_768_avif = REPLACE(imagen_768_avif, 'http://pide-facil.test', 'https://api.pescadores.mx');

/*CABLE MEXICO*/
UPDATE imagens
SET
  url = REPLACE(url, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  scale = REPLACE(scale, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  thumb = REPLACE(thumb, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  thumb_xs = REPLACE(thumb_xs, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  url_webp = REPLACE(url_webp, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  scale_webp = REPLACE(scale_webp, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  thumb_webp = REPLACE(thumb_webp, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  thumb_xs_webp = REPLACE(thumb_xs_webp, 'http://pide-facil.test', 'https://api.cablemexico.com.mx');

UPDATE banners
SET
  imagen = REPLACE(imagen, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  imagen_1920 = REPLACE(imagen_1920, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  imagen_1280 = REPLACE(imagen_1280, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  imagen_768 = REPLACE(imagen_768, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  imagen_frontal = REPLACE(imagen_frontal, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  imagen_frontal_768 = REPLACE(imagen_frontal_768, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  imagen_frontal_460 = REPLACE(imagen_frontal_460, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  imagen_frontal_avif = REPLACE(imagen_frontal_avif, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  imagen_frontal_768_avif = REPLACE(imagen_frontal_768_avif, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  imagen_frontal_460_avif = REPLACE(imagen_frontal_460_avif, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  imagen_avif = REPLACE(imagen_avif, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  imagen_1920_avif = REPLACE(imagen_1920_avif, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  imagen_1280_avif = REPLACE(imagen_1280_avif, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  imagen_768_avif = REPLACE(imagen_768_avif, 'http://pide-facil.test', 'https://api.cablemexico.com.mx');

UPDATE categorias
SET
  imagen = REPLACE(imagen, 'http://pide-facil.test', 'https://api.cablemexico.com.mx'),
  imagen_recorte = REPLACE(imagen_recorte, 'http://pide-facil.test', 'https://api.cablemexico.com.mx');

UPDATE terminos
SET
  imagen = REPLACE(imagen, 'http://pide-facil.test', 'https://api.cablemexico.com.mx');
