How to select rows that have current day’s timestamp?

by

use DATE and CURDATE()

SELECT * FROM `table` WHERE DATE(`timestamp`) = CURDATE()

Warning! This query doesn’t use an index efficiently. For the more efficient solution see the answer below

see the execution plan on the DEMO

More Related Contents:

  1. Group mysql query by 15 min intervals
  2. Calculating time difference between 2 dates in minutes
  3. When is a timestamp (auto) updated?
  4. SQL Query needed for fetch value from Two identical table but not fully identical table
  5. SQL select only rows with max value on a column [duplicate]
  6. How to create a MySQL hierarchical recursive query?
  7. How to reset AUTO_INCREMENT in MySQL
  8. MySQL Query GROUP BY day / month / year
  9. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  10. Combining UNION and LIMIT operations in MySQL query
  11. MySQL comparison with null value
  12. MySQL Like multiple values
  13. Matching all values in IN clause
  14. INTERSECT in MySQL
  15. Search all columns of a table using a single where condition with single keyword in mysql
  16. What does SQL clause “GROUP BY 1” mean?
  17. Case statement in MySQL
  18. MySQL: Inner join vs Where [duplicate]
  19. Syntax error when using except in a query
  20. Selecting from two tables with inner join and limit [duplicate]
  21. Why the order of evaluation for expressions involving user variables is undefined?
  22. ALTER table – adding AUTOINCREMENT in MySQL
  23. sql like operator on integer
  24. MySQL – SELECT * INTO OUTFILE LOCAL ?
  25. How to SELECT by MAX(date)?
  26. The best way to remove value from SET field?
  27. MySQL OPTIMIZE all tables?
  28. Strip last two characters of a column in MySQL
  29. is there a length limit to group_concat or another reason why it would not work on a text field
  30. Deleting a row based on the max value

Leave a Comment