and i want to banned them
but its hard for me to search for email one by one
so i was thinking of making a query to get the user_id by searching for the email
select user_id from xf_user where email like '%firstname.lastname@example.org%'
UPDATE `xf_user` SET `user_group_id` = '6', `is_banned` = '1' WHERE `xf_user`.`user_id` =x; // where x the id i got from last query
sorry =( i didnt work with files in php =(
and is my query is ok or there is another way to do that ?