2 FROM email_virtual
AS e1
3 INNER JOIN email_virtual
AS e2
4 WHERE e1.email
= e2.email
AND e1.
domain = e2.
domain AND e1.redirect
!= e2.redirect
5 AND e1.redirect
= REPLACE(e2.redirect
, '@m4x.org', '@polytechnique.org');
7 SET redirect
= REPLACE(redirect
, '@m4x.org', '@polytechnique.org')
8 WHERE redirect
LIKE '%@m4x.org';
10 -- vim:set syntax=mysql: