Is it possible to remove all users with a certain kind of email address, For example remove everyone who has an email such as @spam.com ?
Remove All With A Certain Email Type
Collapse
X
-
Tags: None
-
I recommend you run a query to put those users into a new group, then prune by group. Use this query:
Code:UPDATE user SET usergroupid = [color=red]X[/color] WHERE email LIKE '%@spam.com%'
Admin CP -> Users -> Prune / Move Users -
-
Comment
-
Can anyone provide guidance on how to apply this query to a custom profile field? Here is what I have:
Code:UPDATE user SET usergroupid = 10 WHERE $bbuserinfo[field6] LIKE [EMAIL="'%@%'"]'%html%'[/EMAIL]
Thanks in advance.Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment