如何在mysql和php中选择哪个月？

Question

How to select where month in mysql and php ?

SELECT * FROM `myTable` WHERE insert_date=MONTH($_POST['month']);

Type insert_date = datetime

here code for input post month:

<select name="month">
<option value="" selected>Choose Month :</option>
<option value="1">January</option>
<option value="2">February</option>
<option value="3">Maret</option>
<option value="4">April</option>
<option value="5">Mei</option>
<option value="6">Juny</option>
<option value="7">July</option>
<option value="8">Augustus</option>
<option value="9">September</option>
<option value="10">Oktober</option>
<option value="11">November</option>
<option value="12">Desember</option>
</select>

</div>

Answer 1

Query should be like this

SELECT * FROM myTable WHERE MONTH(insert_date)=$_POST['month'];