Finding a user by email?

[diorgirly]

Hi there. I hope this is the right forum to post this.

I have a bit of a situation on my board. There's a girl that is stealing photographs from my gallery, but I only know her email address. Is there a way I can search my user database with the email and find her profile? I would really appreciate any help.

Thanks in advance...

[Stramm]

in phpmyadmin (if you have it) click the database name on the leftside menu. Now in topmenu SQL
enter in the box

Code Select Expand


SELECT * FROM `prefix_users` WHERE `user_email`='search@me.com';


change 'prefix' to the db prefix you're using