Author Topic: How can I delete a select number of users?  (Read 5540 times)

sam0812

  • Posts: 22
    • View Profile
How can I delete a select number of users?
« on: November 01, 2004, 08:23:45 am »
I want to select 20 out of 30 users to delete.

How can I do this without having to click
on each individuals delete button?

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
How can I delete a select number of users?
« Reply #1 on: November 01, 2004, 11:30:15 am »
This is currently not possible.  A future release will feature checkboxes as you would expect from a professional program.. :)  For now, I recommend clicking the Delete button next to each user and hitting Enter.  This method can be reasonably fast for up to a few dozen users.  My apologies for the inconvenience.
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

sam0812

  • Posts: 22
    • View Profile
delete a select number of users
« Reply #2 on: August 22, 2006, 06:04:35 am »
Hi,

I would like to delete all of my AOL users from my Active list.
Is there a fast way of doing this without having to press the
delete button next to each user?

Thank you.

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
How can I delete a select number of users?
« Reply #3 on: August 22, 2006, 08:49:49 am »
Do you know how to do custom SQL queries with PhpMyAdmin?

Alternately, you can login to ListMail and browse to editconf.php?customcmd=1

The query to permanently delete all aol.com users from list 1 would be:
Code: [Select]
delete from lm_users where email like '%@aol.com' and list = '1';
And to remove them from all lists
Code: [Select]
delete from lm_users where email like '%@aol.com';
Regards :D
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

sam0812

  • Posts: 22
    • View Profile
How can I delete a select number of users?
« Reply #4 on: August 22, 2006, 09:41:40 am »
Hi,

I get a "failed executing command" error when trying
to use the code:
delete from lm_users where email like '%@aol.com' and list = '1';

Are you sure that's the correct code to use?

Thanks.




---------------------------------------
Alternately, you can login to ListMail and browse to editconf.php?customcmd=1

The query to permanently delete all aol.com users from list 1 would be:
Code:
delete from lm_users where email like '%@aol.com' and list = '1';