MySQL: Remove safety suffix form mail column

To remove a suffix (".test") that was added to migrated user emails, use this UPDATE:

UPDATE users SET mail = TRIM(TRAILING '.test' FROM mail);