thanks Knut - that worked ok
"Knut Talman" <knut.talman_at_mytoys.de> wrote in message
news:3CBBF962.AC630740_at_mytoys.de...
> > I'm trying to update the records of multiple users in my database
> > with this query. The problem is that i have about 2000 email addresses
and
> > will therefore need to update each one individualy.
> > Is there a way to change this query so that
> > e.g."where email = 'list, of , emails'
> >
> > UPDATE USERS set NEWS_P = 't', NEWS_HTML_P = 't'
> > where email = 'test_at_test.com';
>
> WHERE email IN ('email1','email2','email3',...);
>
> (if you want to set NEWS_P and NEWS_HTML_P to the same values for every
email
> address in your list).
>
> Regards,
>
> Knut
Received on Tue Apr 16 2002 - 05:32:37 CDT
