Re: Querying a list of values

Hi again,

And hmm, how about the other way round ?

SELECT *
FROM some_table
WHERE some_list contains a given value ?

Like in

WHERE some_list LIKE '%1%'

but only records that have '1' in the list and not '11', '12' etc ?

TIA,

Aarni

On Thursday 18 November 2004 14:49, Vishal Kashyap @ [SaiHertz] wrote:
> Aarni ,
>
>
> How about
>
> SELECT some_id, some_name
> FROM some_table
> WHERE some_id  IN (YOUR LIST seperated with commas)
>
> Or you may go for arrays see contib for it.


--------------
This is a bugfree broadcast to you
from **Kmail**
on **Fedora Core 2** linux system
--------------