On 17/09/15 09:26, Jeremy Harris wrote:
Why not use an SQL coalesce(field, '') ?
Because I wasn't aware of that solution - thank you I think that seems
to work! (Combined with group_concat, else the results aren't concatenated)
> select coalesce(recipients, '') from aliases where recipients =
"blah";
alias1
alias2
> select coalesce(group_concat(recipients), '') from aliases where
recipients = "blah";
alias1,alias2
Cheers,
Nick
--
## List details at https://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
