querying results from mysql in the last 3 hours?

Question

i want to query blog posts from the database created in the last 3 hours,

table

blogs{id,blog_text,date}

date format: datetime

Answer 1

Try this:

SELECT * FROM blogs WHERE date > DATE_ADD(NOW(), INTERVAL -3 HOUR)

Edit: my bad - replaced CURDATE() with NOW() as we're dealing with DateTimes.