mysql统计今日昨日

        SELECT COUNT(*) num
        FROM whistle_case w
        WHERe w.town = #{code}
          AND DATEDIFF(w.create_date, NOW()) = 0
    

 
        SELECT COUNT(*) num
        FROM whistle_case w
        WHERe w.town = #{code}
          AND DATEDIFF(w.create_date, NOW()) = -1