From: Peter Brawley
Date: February 2 2013 6:58pm
Subject: Re: Complex MySQL Select Statement Help
List-Archive: http://lists.mysql.com/mysql/228902
Message-Id: <510D61DB.9010604@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 2013-02-01 10:18 PM, hsv@stripped wrote:
>>>>> 2013/01/31 22:24 -0600, Peter Brawley >>>>
> Is this what you mean?
>
> Select,
> pricelist
> If( !IsNull(specialprice) And specialprice < unitprice And CurDate() Between startingDate And endingDate,
> specialprice,
> unitprice
> ) as used_price
> >From catalog
> Where itemid='WB314';
>
> PB
> <<<<<<<<
> Maybe this is gilding the lily, but if "specialprice" is null, then
> specialprice < unitprice
> is not true

Read again: ...If( !IsNull( specialprice )...

PB
> --and maybe if the null-test is left out it is less clear....
>
>