How to get month from date?

Question

MySQL

I make filters on the site, by city, month and day.
For the city, I did the equation WHERE `city` = $_GET['city']
Here is the query itself:

$cat_result = mysqli_query( "SELECT * FROM `poster` WHERE `cat` = '".$cat_q['id']."' AND `city` = '".$_GET['city']."'");

I can’t make the same filter for month and day, because this data is stored in one column of the datetime format and looks like 0000-00-00 00:00:00
Let’s say the date is 2017-09-21 19:00:00 the month of this date 09. I need it = to $_GET['month'] (Month itself = 09) that is, if I equate the request in this form

$cat_result = mysqli_query( "SELECT * FROM `poster` WHERE `cat` = '".$cat_q['id']."' AND `date` = '".$_GET['month']."'");

will not work because it will be like this 2017-09-21 19:00:00 = 09
And I need to select only the month in the query right away.

Answer 1

Use MONTH .