List:General Discussion« Previous MessageNext Message »
From:ViSolve DB Team Date:January 6 2007 8:50am
Subject:Re: How to access an array variables in a single query
View as plain text  
Hi,

IN operator will do.

For Instance.

SELECT * FROM TABLE1 WHERE id IN ('i1','i2','i3');


Thanks
ViSolve DB Team.

----- Original Message ----- 
From: "VenuGopal Papasani" <venu.papasani@stripped>
To: <mysql@stripped>
Cc: "bharath kumar" <chbharathk@stripped>
Sent: Saturday, January 06, 2007 2:07 PM
Subject: How to access an array variables in a single query


> Dear all,
>   I have got an array variable say a[]={"i1","i2",i3""} now i need to get
> the values from the database that matches i1,i2,i3 for example
>
>                         select * from tablename where i1=a[1]  and
> simillaryly to a[2] and a[3] but my list is too big one more option i can
> write it through loop but it takes time.Is there any possibility of 
> writing
> a single query to retrieve all that data.
>
>           Awaiting your reply
>
> Thanks and Regards,
> venu
>
> -- 
> ధన్యవాదములతో,
> వేణుగోపాల్  పాపసాని.
> 

Thread
How to access an array variables in a single queryVenuGopal Papasani6 Jan
  • Re: How to access an array variables in a single queryViSolve DB Team6 Jan
    • Re: How to access an array variables in a single queryVenuGopal Papasani6 Jan
      • Re: How to access an array variables in a single queryDan Nelson6 Jan
      • RE: How to access an array variables in a single queryJerry Schwartz8 Jan
        • Re: How to access an array variables in a single queryBrent Baisley8 Jan
          • RE: How to access an array variables in a single queryJerry Schwartz8 Jan
  • Re: How to access an array variables in a single queryViSolve DB Team6 Jan