How can I view all the users registered with a particular email?

How can I view all the users registered with a particular email? - Printable Version

+- MyBB Codes (http://www.mybbcodes.com)
+-- Forum: Babjusi's Previous Forum General Stuff (/forumdisplay.php?fid=42)
+--- Forum: General Support (/forumdisplay.php?fid=46)
+--- Thread: How can I view all the users registered with a particular email? (/showthread.php?tid=1128)

How can I view all the users registered with a particular email? - roger - 12-05-2009 10:58 AM

Is there any way to do that or do I need a plug-in for this?

RE: How can I view all the users registered with a particular email? - babjusi - 12-05-2009 01:09 PM

(12-05-2009 10:58 AM)roger Wrote: Is there any way to do that or do I need a plug-in for this?

The easiest way in my opinion would be to do it from the phpmyadmin at the cp of your host. Run the following query there at the SQL tab:

Code:[Highlight]

SELECT * FROM mybb_users WHERE email LIKE '%hotmail.com';

In this case I chose to view the users with the ...@hotmail.com emails. You can substitute the hotmail.com with the email provider that you want.

RE: How can I view all the users registered with a particular email? - roger - 12-08-2009 08:24 PM

Thank you. I substituded the hotmail.com with wanadoo.fr emails that I wanted to see and it worked great. Thank you again babjusi.

RE: How can I view all the users registered with a particular email? - babjusi - 12-09-2009 06:05 AM

No problem, glad to have been of help.