On Thu, Jan 13, 2011 at 02:27:45AM +0100, mouss wrote: > the idea is
No, the idea is rather different. > mysql> select substring_index("joe....@example", ".", -1); > +---------------------------------------------+ > | substring_index("joe....@example", ".", -1) | > +---------------------------------------------+ > | j...@example | > > > so simply use > virtual_alias_maps = > ... > old_dotted_addr.cf > > then set QUERY as above. This fails to validate the address. Just dropping a prefix can be done more easily with regexp table, and will contstrained to the right domain. The substring thus derived has to be *joined* with a table of valid "base" user logins. -- Viktor.