I am trying to retrieve all data from table in a specific month, my date format in the database table is
SELECT * FROM t_tenancy_details WHERE
agreement_date >= DATE_FORMAT( CURRENT_DATE - INTERVAL 1 MONTH, '%Y/%m/01' )AND
agreement_date < DATE_FORMAT( CURRENT_DATE, '%Y/%m/01' )
It looks you are asking for a real example try it
SELECT * FROM t_tenancy_details where MONTH(date) = MONTH('2016-05-01') AND YEAR(date) = YEAR('2016-05-01')
This will select automatically 05 month form the date like also year too. and simply you can also make this input change as your wish.