SELECT * FROM users WHERE created >= CURDATE();
But I think you mean created < today
You can compare datetime with date, for example: SELECT NOW() < CURDATE()
gives 0
, SELECT NOW() = CURDATE()
gives 1
.
SELECT * FROM users WHERE created >= CURDATE();
But I think you mean created < today
You can compare datetime with date, for example: SELECT NOW() < CURDATE()
gives 0
, SELECT NOW() = CURDATE()
gives 1
.