MySQL: Remove safety suffix form mail column - Gizra/KnowledgeBase GitHub Wiki
To remove a suffix (".test") that was added to migrated user emails, use this UPDATE:
UPDATE users SET mail = TRIM(TRAILING '.test' FROM mail);
To remove a suffix (".test") that was added to migrated user emails, use this UPDATE:
UPDATE users SET mail = TRIM(TRAILING '.test' FROM mail);