Re: multiple update

> 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:13:54 CDT