Re: doing query for an array of strings yataaa wrote:
> Hi!
>
> What I would like to do is this:
> SELECT * FROM 'tableName' WHERE ColumnName is in ARRAY
>
> and ARRAY has the form of a set or array, like {"foo", "bar", "raz",
> "ma", "taz"}. I can't do it like "...WHERE ColumnName='foo' OR
> ColumnName='BAR' OR ..." because I don't know those strings and how
> many of them are in the set before.
Where will your set come from in the first place? How will you construct
your array of values? If you can construct them in this sort of array/set
format, why could you not construct them in the ColumnName='foo' OR
ColumnName='BAR' OR ..., just as easily? |