Changing all AOL "Bounced" Records to "Active

[DB]

I have a list of over 4000 addresses with over 900 AOL addresses  marked "Bounced" because of a problem with AOL that has now been resolved.  I want to change these AOL addresses back to "Active".  Is there an easy way to do this without having to edit each individual record?

[DW]

If you know how to run a custom command with PhpMyAdmin, try the following MySQL query:

(users marked as bounced have "cnf" set to "2", active users have a value of "1")

Code: [Select]

update lm_users set cnf = '1' where email like '%@aol.com';