Author Topic: Changing all AOL "Bounced" Records to "Active  (Read 1724 times)

DB

  • Posts: 12
    • View Profile
Changing all AOL "Bounced" Records to "Active
« on: August 29, 2004, 10:01:46 am »
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

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Changing all AOL "Bounced" Records to "Active
« Reply #1 on: August 30, 2004, 06:08:21 am »
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';
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting