Select mysql query between date?

by 
select * from *table_name* where *datetime_column* between '01/01/2009' and curdate()

or using >= and <= :

select * from *table_name* where *datetime_column* >= '01/01/2009' and *datetime_column* <= curdate()

More Related Contents:

  1. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  2. MySQL Query – Records between Today and Last 30 Days
  3. How to get an age from a D.O.B field in MySQL?
  4. How do I get the first day of the week of a date in mysql?
  5. Compare only day and month with date field in mysql
  6. Recreating a query using INNER JOIN? [duplicate]
  7. MySQL – UPDATE query based on SELECT Query
  8. How to convert a string to date in MySQL?
  9. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  10. Converting a date in MySQL from string field
  11. MySQL: Select All Dates In a Range Even If No Records Present
  12. Ordering by specific field value first
  13. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  14. CURRENT_DATE/CURDATE() not working as default DATE value
  15. INSERT INTO…SELECT for all MySQL columns
  16. MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result
  17. Get the latest date from grouped MySQL data
  18. MySQL difference between two rows of a SELECT Statement
  19. MySQL – How to search for exact word match using LIKE?
  20. Count days between two dates, excluding weekends (MySQL only)
  21. How to select the most recent set of dated records from a mysql table
  22. MySQL date format
  23. quick selection of a random row from a large table in mysql
  24. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  25. SELECT query return 1 row from each group
  26. Comma separated string of selected values in MySQL
  27. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  28. MySQL Error: #1142 – SELECT command denied to user
  29. MySQL cumulative sum grouped by date
  30. MySQL cartesian product between two SELECT statements

Leave a Comment