mysql date

mysql常用日期query

//注意結尾，否則只會出現到前一天的資料 NOW()- INTERVAL 1

$sql = 'SELECT * FROM mission WHERE(NOW()- INTERVAL 1 DAY BETWEEN start AND end ) and state=1 order by start DESC ';