MySQL: How to select records for this week?

by

Use YEARWEEK():

SELECT *
FROM   your_table
WHERE  YEARWEEK(`date`, 1) = YEARWEEK(CURDATE(), 1)

More Related Contents:

  1. Left Outer Join doesn’t return all rows from my left table?
  2. How to populate a table with a range of dates?
  3. How to convert a string to date in MySQL?
  4. MySQL Query GROUP BY day / month / year
  5. How to get the number of days of difference between two dates on MySQL?
  6. Converting a date in MySQL from string field
  7. MySQL: Select All Dates In a Range Even If No Records Present
  8. Mysql: Select all data between two dates
  9. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  10. MySQL Query – Records between Today and Last 30 Days
  11. CURRENT_DATE/CURDATE() not working as default DATE value
  12. How to get difference between two dates in months using MySQL query?
  13. Select mysql query between date?
  14. How to select date from datetime column?
  15. Get the latest date from grouped MySQL data
  16. mysql: get record count between two date-time
  17. How to get first day of every corresponding month in mysql?
  18. Count days between two dates, excluding weekends (MySQL only)
  19. How to select the most recent set of dated records from a mysql table
  20. How to cast DATETIME as a DATE in mysql?
  21. MySQL date format
  22. Select all months within given date span, including the ones with 0 values
  23. Update date + one year in mysql
  24. mysql date comparison with date_format
  25. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  26. MySQL cumulative sum grouped by date
  27. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  28. MySQL: Find Missing Dates Between a Date Range
  29. How do I extract Month and Year in a MySQL date and compare them?
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment