MySQL, Coldfusion, selection of records marked in the last 24 hours

Question

With Coldfuson and MySQL - How do I update a query to check for new records that have a timestamp that occurs in the last 24 hours?

Query:

<cfquery name="caller.sel_BlogEntries" datasource="#request.db#"> SELECT blogentry.dateAdded, person.personName FROM blogentry INNER JOIN person ON blogentry.personID = person.personID WHERE blogentry.deleted = 'N' ORDER BY blogentry.dateAdded DESC </cfquery> 

blogentry.dateAdded is MySql TimeStamp

thanks

Answer 1

 WHERE ... AND DATE_ADD(blogentry.dateAdded, INTERVAL 1 DAY) >= NOW()