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
