How do I select between the 1st day of the current month and current day in MySQL?

by 
select * from table_name 
where (date between  DATE_ADD(LAST_DAY(DATE_SUB(CURDATE(), interval 30 day), interval 1 day) AND CURDATE() )

Or better : 

select * from table_name 
where (date between  DATE_FORMAT(NOW() ,'%Y-%m-01') AND NOW() )

More Related Contents:

  1. Left Outer Join doesn’t return all rows from my left table?
  2. Get a list of dates between two dates
  3. How to convert a string to date in MySQL?
  4. Error in MySQL when setting default value for DATE or DATETIME
  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 WHERE datetime matches day (and not necessarily time)
  9. MySQL Query – Records between Today and Last 30 Days
  10. Difference between two dates in MySQL
  11. CURRENT_DATE/CURDATE() not working as default DATE value
  12. How to select date from datetime column?
  13. Get the latest date from grouped MySQL data
  14. How to get an age from a D.O.B field in MySQL?
  15. mysql: get record count between two date-time
  16. How to get first day of every corresponding month in mysql?
  17. Count days between two dates, excluding weekends (MySQL only)
  18. How to select the most recent set of dated records from a mysql table
  19. How do I get the first day of the week of a date in mysql?
  20. MySQL date format
  21. MySQL: How to select records for this week?
  22. Compare only day and month with date field in mysql
  23. MySQL – select data from database between two dates
  24. How to select only date from a DATETIME field in MySQL?
  25. Insert/ Update random date in MySQL
  26. How to compare timestamp dates with date-only parameter in MySQL?
  27. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  28. MySQL cumulative sum grouped by date
  29. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment