UBB.Developers Forums UBB.threads 7 Development How Do I? SQL query for username and email

I'm sure this is posted in here somewhere... I just couldn't find it.

I need an SQL query that will pull out all usernames and their related email address.

Thanks!!
-g

you usualy find things in this thread..

https://www.ubbdev.com/forum/showflat...5/o/all/fpart/1

but for the forumatically challenged its

SELECT U_Username,U_RegEmail,U_Email,U_Fakeemail FROM w3t_USers

use whatever email you are loking for be it the Email they registered with, the email they show others, or the fake one...