mysql >now(),按日期选择条目 - > = NOW（），MySQL

I have a Calendar of Events table and I would like to select events with dates equal to or greater than today. When I use the following SELECT statement, it only retrieves events in the future (> NOW()):

$db->query("SELECT * FROM events WHERE event_date >= NOW()");

?>

How would I go about selecting all events that are either today or in the future?

Thank you

解决方案

You are looking for CURDATE():

$db->query("SELECT * FROM events WHERE event_date >= CURDATE()");

Or:

$db->query("SELECT * FROM events WHERE event_date >= CURRENT_DATE()");