Commit | Line | Data |
---|---|---|
42c3833f SJ |
1 | DELETE e2 |
2 | FROM email_virtual AS e1 | |
3 | INNER JOIN email_virtual AS e2 | |
120baaa5 SJ |
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'); | |
42c3833f SJ |
6 | UPDATE email_virtual |
7 | SET redirect = REPLACE(redirect, '@m4x.org', '@polytechnique.org') | |
8 | WHERE redirect LIKE '%@m4x.org'; | |
9 | ||
10 | -- vim:set syntax=mysql: |