How do I query between two dates using MySQL?

by

Your second date is before your first date (ie. you are querying between September 29 2010 and January 30 2010). Try reversing the order of the dates:

SELECT *
FROM `objects`
WHERE (date_field BETWEEN '2010-01-30 14:15:55' AND '2010-09-29 10:15:55')

More Related Contents:

  1. SQL select only rows with max value on a column [duplicate]
  2. How to create a MySQL hierarchical recursive query?
  3. MySQL: @variable vs. variable. What’s the difference?
  4. Join between tables in two different databases?
  5. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  6. How to select a column name with a space in MySQL [duplicate]
  7. Cannot delete or update a parent row: a foreign key constraint fails
  8. Using union and order by clause in mysql
  9. Can a table field contain a hyphen?
  10. MySQL JOIN the most recent row only?
  11. OUTPUT Clause in MySQL
  12. Search all columns of a table using a single where condition with single keyword in mysql
  13. What does SQL clause “GROUP BY 1” mean?
  14. Sorting by date & time in descending order?
  15. Case statement in MySQL
  16. MySQL, Concatenate two columns
  17. MySQL: Inner join vs Where [duplicate]
  18. Syntax error when using except in a query
  19. Selecting from two tables with inner join and limit [duplicate]
  20. Why the order of evaluation for expressions involving user variables is undefined?
  21. sql like operator on integer
  22. How to select data where a field has a min value in MySQL?
  23. MySQL – SELECT * INTO OUTFILE LOCAL ?
  24. How to SELECT by MAX(date)?
  25. The best way to remove value from SET field?
  26. get a recursive parent list
  27. INSERT INTO Table from multiple tables
  28. Execute INSERT if table is empty?
  29. Mysql How do you create a clustered index?
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment