1、if(exp1,exp2,exp3)
当exp1!=0&&exp1!=null时,输出exp2,反之exp3
example:
IF(date.date=NOW(),timeslot.open_time IN (SELECT timeslot.open_time
FROM timeslot where timeslot.open_time>curtime()) ,’1=1’)
2、CASE WHEN exp1 THEN exp2 else exp3 END
当exp1!=0&&exp1!=null时,输出exp2,反之exp3