$today = date("Y-m-d");
$specialDayQuery = $db->prepare("SELECT * FROM specialDays WHERE specialday_date = ?");
$specialDayQuery->execute(array(
    $today
));
if($specialDayQuery->rowCount() > 0){
   echo("Özel gün.");
}