Re: doing query for an array of strings yataaa wrote:
> Peter H. Coffin schrieb:
>
>> ... WHERE ColumnName IN ('val1', 'val2', 'val3' ... );
>
> Oh great, thats exactly what I wanted.
>
>> is the right way to construct that. There is a way to do it without
>> knowing the match values beforehand, but Paul yells when people talk
>> about it. You might be able to put your match terms into a temporary
>> table and join against it.
>
> Yes, I thought about that, too. But I couldn't figure out the way to
> do that.. Is that kind of "unclean" mySQL, or why does he yell?
I don't know either.
See my other post in this tread, asking about where your values are coming
from and how you intend to construct your array. |