MySQL statement help

[hawkmultimedia]

I'm transferring newsletter subscribers into YANC from an old list. I've managed to import the e-mail addresses. Now, if I can just get the statement to change the list_id and confirmed from 0 to 1 without going through each record individually. I'd also like to copy the subscriber_e-mail values to subsciber_name, but when I try, it just creates new name records without e-mails.

Any pointers?

Thanks!

[spleen]

UPDATE db_table_name SET list_id = 1

ALTER TABLE db_table_name CHANGE subscriber_e-mail subsciber_name
(this renames the field - dunno if you want that)

greez

[hawkmultimedia]

Sweet! Thanks, Spleen.

I didn't want to change the column name, but got the UPDATE statement to work on that as well.

UPDATE mos_newsletter_subscribers SET subscriber_name=subscriber_e-mail;

Thanks again!!

[spleen]

youre welcome