Now that I'm looking at it, doesn't DBMail want to deliver to ALL the aliases
that match in the table? So we wouldn't want limit anyhow, right?
-Micah
On Wednesday 20 October 2004 01:26 am, Ilja Booij wrote:
> On Tue, 19 Oct 2004 16:07:18 -0700, Micah <[EMAIL PROTECTED]> wrote:
> > How about this, as concat seems to be in both MySQL and PG:
> >
> > SELECT * from dbmail_aliases WHERE 'delivery_address' LIKE concat('%',
> > alias, '%') limit 1;
>
> LIMIT is a bit nasty. It's not SQL92, only in MySQL and PGSQL. I'm not
> in favour of using it in queries in DBMail.
>
> Ilja
> _______________________________________________
> Dbmail-dev mailing list
> Dbmail-dev@dbmail.org
> http://twister.fastxs.net/mailman/listinfo/dbmail-dev
