Code: Select all
SELECT username FROM phpbb_users WHERE user_email LIKE '%sinas.com%';
*@sina.com
in the email box and check the appropriate boxes and click submit. you will get a list of all the users with that email domain and you can choose what to do with them .