Abhi,
I might not be understanding the problem but could you use the max
and min timestamp values and use something like
SELECT * FROM TABLE WHERE start BETWEEN max AND min AND end BETWEEN max AND min
or
SELECT * FROM TABLE WHERE START IN (1,2,3,4,5) AND END IN(1,2,3,4,5)
I might be completely off-base here though as I don't think I fully
comprehend what you're trying to do.
Kyong
At 09:36 AM 5/8/2009, Abhishek Pratap wrote:
aah okie I think I was trying to get too clever. Guess that won't work ...
Thanks,
-Abhi
On Fri, May 8, 2009 at 12:34 PM, Barney Boisvert <bboisv...@gmail.com>wrote:
> You'll have to iterate over your two lists of timestamps and build a
> set of ORed conditional pairs:
>
> sql = "select ... from ... where 1 = 0"
> for (i = 0; i < timestamps.length; i++) {
> sql += " or start <=" + timestamps[i] + " and end >= " + timestamps[i]
> }
>
> You'll want to use bind parameters in real life, of course.
>
> cheers,
> barneyb
>
> On Fri, May 8, 2009 at 9:26 AM, Abhishek Pratap <abhishek....@gmail.com>
> wrote:
> > 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
> >
>
>
>
> --
> Barney Boisvert
> bboisv...@gmail.com
> http://www.barneyb.com/
>
Kyong Kim
Instructional Multimedia/Web Programmer
Foothill College
12345 El Monte Rd
3601
Los Altos Hills, CA 94022
650-949-7091
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
