From: hsv
Date: February 2 2013 4:18am
Subject: Re: Complex MySQL Select Statement Help
List-Archive: http://lists.mysql.com/mysql/228901
Message-Id: <B0124508584@mailhome.tbbs.net>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

>>>> 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--and maybe if the null-test is left out it is less clear....