title: How to filter a date column based on month in MySQL
body: <p>I'm trying to filter a date column based on month:</p>
  
  <pre><code>SELECT  id, nama, lahir_tanggal  
  FROM `alumni_db.alumni_tb`   
  WHERE date("F", strtotime('lahir_tanggal') = "August";
  </code></pre>
  
  <p><code>lahir_tanggal</code> is in date format</p>
  
  <p>How to make that query work?</p>