Datetime equal or greater than today in MySQL?

Question

What's the best way to do following: SELECT * FROM users WHERE created >= today; Note: created is a datetime field.

Answer 1

MySQL syntax offers many date and time functions that you can use to for datetime compares.

https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html

In your case, I think the most effective, depending the data contained in the "created" field, would be:

CURDATE() - today's date

CURTIME() - the time on the server at the moment this function is executed

NOW() - the date and time on the server at the moment this function is executed

I would start with those.