Forum Moderators: open
I am using MySQL in a PHP environment.
In a MySQL query I would like to limit my search to just results published today.
mysql_query("SELECT * FROM table WHERE published>='".date("Y-m-d")." 00:00:00'");
That works great.
But how would I go about selecting dates published just yesterday?
mysql_query("SELECT * FROM table WHERE published>='YESTERDAY()' AND published<'".date("Y-m-d")." 00:00:00'");?
SELECT * FROM table
WHERE published >= CURDATE()
for items published today and
SELECT * FROM table
WHERE published >= DATE_SUB(CURDATE(), INTERVAL 1 DAY) AND published < CURDATE()
for yesterday?
