MySQL Query to select data from last week?

by 
select id from tbname
where date between date_sub(now(),INTERVAL 1 WEEK) and now();

More Related Contents:

  1. How to select the nth row in a SQL database table?
  2. MySQL Query GROUP BY day / month / year
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. Error Code: 2013. Lost connection to MySQL server during query
  5. Storing JSON in database vs. having a new column for each key
  6. Difference between two dates in MySQL
  7. How do I restore a dump file from mysqldump?
  8. Using an Alias in SQL Calculations
  9. Can a table field contain a hyphen?
  10. Adding a leading zero to some values in column in MySQL
  11. SQL Query to show nearest date?
  12. View’s SELECT contains a subquery in the FROM clause
  13. Check for x consecutive days – given timestamps in database
  14. MySQL Insert Into from one Database in another
  15. How do I get the ID of multiple inserted rows in MySQL?
  16. How to insert data to MySQL with auto-incremented column(field)?
  17. Case statement in MySQL
  18. Replace Into Query Syntax
  19. Remove special characters from a database field
  20. MySQL query, MAX() + GROUP BY
  21. How to get multiple records against one record based on relation?
  22. MySQL – Replace Character in Columns
  23. Create date from day, month, year fields in MySQL
  24. FIND_IN_SET with multiple value [duplicate]
  25. Foreign key constraints: When to use ON UPDATE and ON DELETE
  26. How to use a user variables in MySQL LIKE clause?
  27. MySQL: Insert datetime into other datetime field
  28. Selecting distinct 2 columns combination in mysql
  29. How to store a one to many relation in MySQL database?
  30. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;

Leave a Comment