php - 如何在 mysql 和 php 中选择月份？

Question

如何在mysql和php中选择月份？

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

输入 insert_date = datetime

此处输入帖子月份的代码:

<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>

Answer 1

查询应该是这样的

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