sql - Selecting entries by date - >= NOW(), MySQL

Question

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()):

<?php    
$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

Answer 1

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()");