SELECT * FROM messages
    -> WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) <= message_data;