Author: Hr. Daniel Mikkelsen Date: To: Eli CC: exim-users Subject: Re: [Exim] Syntax for a MySQL select true/false statement
On Wed, 18 Jun 2003, Eli wrote:
> Or whatever, but have it do a true/false depending on if the SELECT returns
> NULL or NOT NULL (ie, an email address to forward to).
>
> Can someone show me the syntax for doing that if possible, and if not, maybe
> suggest what an alternative is?
Can't you just do this in your select statement?
SELECT myvar1 = myvar2 OR myvar1 = 'foobar' FROM ...
I do stuff like this in my conditions with PostGreSQL at least. Don't
underestimate SQL. :)