Re: [Exim] Syntax for a MySQL select true/false statement

Góra strony
Delete this message
Reply to this message
Autor: Hr. Daniel Mikkelsen
Data:  
Dla: Eli
CC: exim-users
Temat: 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. :)

-- Daniel