date sql query

[greedyisg00d]

I have a schedule table and it has 3 fields by default namely e_name, date_from, date_to. For example

e_name = greedyisgood
date_from = 2009/03/05
date_to = 2009/03/10

In my search page I have 2 fields date_from and date_to. What I want is when the user sets a date in the search for example.

date_from = 2009/03/01
date_to = 2009/03/06

The record of greedyisgood will not be shown since he has already a schedule on the date entered by the user.

Any sample query so that I can try it. Thanks

[Weedpacket]

No point trying an "example" query because it wouldn't work. Understanding it would be more productive.

I presume you mean you store date ranges, and the user gives a date range, and you want all records with date ranges that do not overlap the user's given date range.

Two ranges do not overlap if either ends before the other begins.

NOT((date_to < $user_date_from) OR ($user_date_to < date_from))