How to write a query to the MySQL database with a selection by date?

Question

MySQL

How to write a query to the MySQL database to get all the data for a certain calendar month (there is a date field in the database)?

Answer 1

SELECT * 
  FROM `table` 
  WHERE `date` BETWEEN '2016-05-01' AND LAST_DAY('2016-05-01')