How to filter a date column based on month in MySQL -

i'm trying filter date column based on month:

select  id, nama, lahir_tanggal   `alumni_db.alumni_tb`    date("f", strtotime('lahir_tanggal') = "august"; 

lahir_tanggal in date format

how make query work?

select id, nama, lahir_tanggal    alumni_db.alumni_tb      monthname(lahir_tanggal) ="august" 

or

select id, nama, lahir_tanggal    alumni_db.alumni_tb      month(lahir_tanggal) =8 

see here