I guess that would work, but it could get make my tables quite large.
Hoping there are some other ways.
Thanks though! :)
-Allan
On Thu, 21 Sep 2000 13:34:47 -0400, George Schlossnagle wrote:
>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/ ##
>
>--
>## List details at http://www.exim.org/mailman/listinfo/exim-users Exim details at http://www.exim.org/ ##
>
<- Allan Rafuse ->
Systems Administrator
Freeview Publishing Inc.
email: allan@???
web:
http://www.freeview.com