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.
