MySQL SELECT last few days?

by

Use for a date three days ago:

WHERE t.date >= DATE_ADD(CURDATE(), INTERVAL -3 DAY);

Check the DATE_ADD documentation.

Or you can use:

WHERE t.date >= ( CURDATE() - INTERVAL 3 DAY )

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. Create a Cumulative Sum Column in MySQL
  3. MySQL – Get row number on select
  4. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  5. Equivalent of explode() to work with strings in MySQL
  6. How can I tell when a MySQL table was last updated?
  7. mysql select dynamic row values as column names, another column as value
  8. Operand Should Contain 1 Column – MySQL NOT IN
  9. MySQL DELETE FROM with subquery as condition
  10. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  11. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  12. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  13. Simple Random Samples from a Sql database
  14. MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB
  15. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  16. Determine Rank based on Multiple Columns in MySQL
  17. Checking multiple columns for one value
  18. What is better in MYSQL count(*) or count(1)?
  19. Delete query not working in mysql
  20. Best practices for SQL varchar column length [closed]
  21. How to get current date & time in MySQL?
  22. Laravel join with 3 Tables
  23. SELECT query return 1 row from each group
  24. MySql Single Table, Select last 7 days and include empty rows
  25. mysql SQL: specific item to be first and then to sort the rest of the items
  26. How to regex in a MySQL query
  27. MySQL Group By Hours
  28. RMySQL dbWriteTable with field.types
  29. Syntax error on MERGE statement
  30. ORDER BY alphabet first then follow by number

Leave a Comment