Returning records from the last 3 months only in MySQL

by

3 months before today:

select * from table where timestamp >= now()-interval 3 month;

Start with first of month:

select * from table where timestamp >= last_day(now()) + interval 1 day - interval 3 month;

More Related Contents:

  1. SELECTING with multiple WHERE conditions on same column
  2. grant remote access of MySQL database from any IP address
  3. Should MySQL have its timezone set to UTC?
  4. JDBC batch insert performance
  5. SQL – Update multiple records in one query
  6. How to find gaps in sequential numbering in mysql?
  7. Can I create view with parameter in MySQL?
  8. MySQL: Invalid use of group function
  9. Scaling solutions for MySQL (Replication, Clustering)
  10. MySQL show status – active or total connections?
  11. MySQL dynamic pivot table
  12. mysql check if numbers are in a comma separated list
  13. mySQL DataSource on Visual Studio 2012
  14. MySQL update case help
  15. Dropping Unique constraint from MySQL table
  16. limiting the rows to where the sum a column equals a certain value in MySQL
  17. MySql Transpose Row into Column and Column into Row [duplicate]
  18. Dump a mysql database to a plaintext (CSV) backup from the command line
  19. Mysql select distinct
  20. Mysql permission errors with ‘load data’
  21. How to select column names dynamically in mySQL
  22. How would I use ON DUPLICATE KEY UPDATE in my CodeIgniter model?
  23. MySQL concatenating all columns
  24. Transpose rows into columns in MySQL
  25. MySQL Join Where Not Exists
  26. MYSQL declaring variables
  27. get a recursive parent list
  28. Trouble with GROUP_CONCAT and Longtext in MySQL
  29. How to pass a variable to a IN clause?
  30. How can I make a table in MySQL called “order”?

Leave a Comment