Check if the current date is between two dates

Hello,

I have a table with the folowing fields:
- id (int)
- event_title (text)
- event_description (text)
- event_start (date)
- event_end (date)

I would like to know how can I build a query to select the events available between two dates (event_start and event_end).

For example, if one of the event has "event_start" = 2007-06-01 and "event_end" = 2007-06-05, if I select 2007-06-02 as the current date I would like to see this event.

Thanks in advance.

 

(DATEDIFF(event_start, NOW()) >= 0 AND DATEDIFF(NOW(), event_end) <= 0)

Code (markup):

 

Thanks! It works.