Query to get all rows from previous month

by 
SELECT * FROM table
WHERE YEAR(date_created) = YEAR(CURRENT_DATE - INTERVAL 1 MONTH)
AND MONTH(date_created) = MONTH(CURRENT_DATE - INTERVAL 1 MONTH)

More Related Contents:

  1. If two columns are 1 then make new column
  2. Can we use CONCAT and JOIN together in MySQL? [closed]
  3. Truncate all tables in a MySQL database in one command?
  4. Retrieving the last record in each group – MySQL
  5. Find distance between two points using latitude and longitude in mysql
  6. How to convert result table to JSON array in MySQL
  7. CROSS/OUTER APPLY in MySQL
  8. MySQL Event Scheduler on a specific time everyday
  9. How do I add a custom CHECK constraint on a MySQL table?
  10. How to store uuid as number?
  11. Export and Import all MySQL databases at one time
  12. How to access a RowDataPacket object
  13. Update row with data from another row in the same table
  14. tomcat7 – jdbc datasource – This is very likely to create a memory leak
  15. Select from one table where not in another
  16. MySQL password function
  17. phpMyAdmin is throwing a #2002 cannot log in to the mysql server phpmyadmin
  18. How to select the most recent set of dated records from a mysql table
  19. MySQL database with unique fields ignored ending spaces
  20. Selecting multiple columns/fields in MySQL subquery
  21. Set value to NULL in MySQL
  22. How to rearrange MySQL columns?
  23. mysql DECLARE WHILE outside stored procedure how?
  24. How can I check MySQL engine type for a specific table?
  25. mySQL UPDATE query returns “0 rows affected”
  26. When is a timestamp (auto) updated?
  27. Should I normalize my DB or not?
  28. How can I stop a MySQL query if it takes too long?
  29. “General error: 1005 Can’t create table” Using Laravel Schema Build and Foreign Keys
  30. django cannot connect mysql in docker-compose

Leave a Comment