How to select data from SQL table for the last day, by datetime field?

Question

MySQL

There is a table in which there is a created column with the datetime format: 2015-11-20 15:22:47
You need to get all rows from the table, according to the created field for the last day, the nearest one (it can be either today or a few days ago), which is in the table.
SELECT * FROM table WHERE created=?
Is it possible to do with one request?

Answer 1

SELECT `t`.* 
    FROM (
        SELECT DATE(MAX(`created`)) AS `date`
            FROM `table`
    ) AS `d`
    JOIN `table` AS `t` ON `t`.`created` >= `d`.`date`

Answer 2

select 
t.id, t.date
from table1 t
where t.date >= ( select max(date) from table1 where id = t.id )