title: How to select no of clients with today birthday?
body: <p>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:</p>
  <pre><code>$stmt = $con-&gt;query(&quot;SELECT * FROM  clients WHERE DATEDIFF(NOW(),'client_dob')&quot;);
    echo(mysqli_num_rows($stmt));
  $stmt-&gt;close();
  </code></pre>
  <p>Any simple solution?</p>