Datetime equal or greater than today in MySQL

n00b picture n00b · Mar 3, 2011 · Viewed 560.6k times · Source

What's the best way to do following:

SELECT * FROM users WHERE created >= today;

Note: created is a datetime field.

Answer

Clodoaldo Neto picture Clodoaldo Neto · Mar 3, 2011
SELECT * FROM users WHERE created >= CURDATE();

But I think you mean created < today