View Single Post

   
  #8 (permalink)  
Old 02-28-2008, 11:32 AM
Paul Lautman
 
Posts: n/a
Default 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.


Reply With Quote