buscar-repetidos-actualizar-dominios.sql

buscar-repetidos-actualizar-dominios.sql

--Verificar si va a haber emails repetidos al cambiar todos a @yopmail
-------------------------------------------------------------------------------------------------
SELECT REPLACE(email, SUBSTRING_INDEX(email, '@', -1), 'yopmail.com') as nuevo_email, count(*) as cant
FROM `email` 
GROUP BY nuevo_email
HAVING cant > 1


--Actualizar todos los emais a @yopmail
-------------------------------------------------------------------------------------------------
UPDATE email
SET email = REPLACE(email, SUBSTRING_INDEX(email, '@', -1), 'yopmail.com');

UPDATE fos_user
SET
email = REPLACE(email, SUBSTRING_INDEX(email, '@', -1), 'yopmail.com'),
email_canonical = REPLACE(email_canonical, SUBSTRING_INDEX(email_canonical, '@', -1), 'yopmail.com');