I am trying to count num rows of clients with today's birthday. The problem is, I don't know how I can remove Y from the query (client_dob Format is 1995-12-28) I trying to achieve this using this code:
$stmt = $con->query("SELECT * FROM clients WHERE DATEDIFF(NOW(),'client_dob')");
echo(mysqli_num_rows($stmt));
$stmt->close();
Any simple solution?