just have multipe expansions for the alias, one row per.
my query is
query = select expansion from aliases where local_part='${local_part}'
&& domain='${domain}'
then in my table I just have one row per expansion per local_part@domain
(the mailing list):
insert into aliases (expansion,local_part,domain)
values('bob@???','mylist','mydomain');
insert into aliases (expansion,local_part,domain)
values('sue@???','mylist','mydomain');
insert into aliases (expansion,local_part,domain)
values('joe@???','mylist','mydomain');
Allan Rafuse wrote:
>
> I'm using Mysql to store my usernames. Is there a way to
> create a "mailling list" inside a table?
>
> IE: if I send to list@???, can I use a SQL statement
> such as: select forward from emails where alias = ${localpart}
>
> where the forward line contains something like:
> allan@???; allan1@???; allan2@???
>
> I currently use the foward field to forward the users mail which works,
> but can exim send it to multiple accounts in such a fashion?
>
> -Allan
>
> <- Allan Rafuse ->
> Systems Administrator
> Freeview Publishing Inc.
> email: allan@???
> web: http://www.freeview.com
>
> --
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim details at http://www.exim.org/ ##
