I am trying to write a query that would return the following: all items that are new today and all items ending today.
Whats would be the optimal mysql query for a large recordset.
select * from item_tbl where now() -creation_date <= 24
select * from item_tbl where (close_date - now()) <= 24
Whats would be the optimal mysql query for a large recordset.
select * from item_tbl where now() -creation_date <= 24
select * from item_tbl where (close_date - now()) <= 24