Help with mysql query, multiple list

[Abhishek Pratap]

Hi All

I am kind of stuck with this query  , cant expand my thinking. May this is a
limitation.  Here it is

I have a database with many cols two of which are start and end position for
an event.

Now I have a list of event time stamps, I want to find all the info once the
current event time stamp is >= start time of event and <=end time of event.

something  like this

select * from table_name where start <= ( LIST of time stamps) AND end >=(
list of time stamps).

Clearly above query accepts only one item in the list. Is there a way to do
this for multiple items in the list ??? I can't think of anything at this
moment.


Thanks,
-Abhi