MySQL query Filter

Question

Hello Everybody

 

i have a this query

 

Select * from Data Where SiteID=?SiteID and MainSID=?MainSID and AreaID=?AreaID and ContentType=?ContentType and now() >= DisplaySDate And now() < DisplayEDate order by SBID asc"

this query for site main banner then i want to show banner on mainpage when i not input DisplaySDate and DisplayEDate, so how to change this part

now() >= DisplaySDate And now() < DisplayEDate

 

i`m thinking this way but not working = ==

 

if(now() >= DisplaySDate, DisplaySDate = '0000-00-00 00:00:00') And if(now() < DisplayEDate, DisplayEDate='0000-00-00 00:00:00')

 

so you r guys have an any idea for this problem