New posts in datestamp

Select records from NOW() -1 Day

mysql select where datestamp