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

##</code><code>##

my $data = qq(SELECT * FROM messages..);
my $sth = $dbh->prepare($data);
$sth->execute();