Get all of the today's items from mysql

[phppaper]

Hello,

 

In my Mysql database, it has a datetime field.

 

and I have created a $today = date('Y-m-d H:i:s');  <-  today's date and time

 

How do I write a query to run in PHP in order to get all today's items by comparing datetime field and $today?

 

Thanks!

[revraz]

You don't need variable for $today, just use now().

 

select * from mytable where mydatefield = now();

[PFMaBiSmAd]

Time is fairly specific and changes all the time. Every new second that goes by makes it kind of hard to match other time values.

 

select * from your_table where DATE(your_datetime_field) = CURDATE();