Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Trying to use "where in" to select from a list

Re: Trying to use "where in" to select from a list

From: Ken Gaul (06) <ken_at_gaul-edin.freeserve.co.uk>
Date: Wed, 19 Jan 2000 09:41:40 +0000
Message-ID: <388586D4.9F704E2B@gaul-edin.freeserve.co.uk>


If I understand correctly what you want is

select data from mytable where instr(contents,'2')>0

Ken.

ellisjb_at_my-deja.com wrote:

> A simplified example: my table has two columns, data (varchar) and
> Contents (varchar). I want to store a list of integers in Contents,
> e.g. '1,2,3,4,5', and do a query like
>
> select data from mytable where 2 in contents;
>
> But this setup doesn't give the desired results; apparently, a
> comma-delimited list in a column can't be used in a "where ... in"
> query this way.
>
> Is there a simple way to accomplish this? Or do I need to have
> to re-organize my tables?
>
> Thanks,
>
> Jonathan Ellis
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jan 19 2000 - 03:41:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US