Check whether below query helps u ? Select * from db where IFNULL(last_renewal_date,signup_date) between '2004-11-01' and '2004-11-30'
Regards --Yoge
Mike Morton wrote:
I am trying to find a list of people based on renewal dates, the logic of the query would be:
Select everything from the db where the last renewal date is between a and b, or if there is no last renewal date then where the signup date is between a and b
The query that I have is something like:
Select * from db where last_renewal_date
between '2004-11-01' and '2004-11-30' or
if(
length(last_renewal_date) < 1,
signup_date between '2004-11-01' and '2004-11-30'
) order by last_renewal_date
Obviously the syntax is wrong here, but is there a way to accomplish this logic using an if statement in the where statement?
TIA!
-- Cheers
Mike Morton
**************************************************** * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED] * ****************************************************
"Indeed, it would not be an exaggeration to describe the history of the computer industry for the past decade as a massive effort to keep up with Apple." - Byte Magazine
Given infinite time, 100 monkeys could type out the complete works of
Shakespeare. Win 98 source code? Eight monkeys, five minutes.
-- NullGrey
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
