E-mail field (Mysql)

[caiovic]

Good afternoon everyone,

I have a doubt ..
In sugar, I use LDAP authentication, and then see all the information of my users ..
I wonder if you know which table and column of the database (mysql) suck it saves the user's email field.

Thanks!

[kurt.maderal]

Hi,

Try checking this query:

select * from users U
left join email_addr_bean_rel ABR on U.id = ABR.bean_id
left join email_addresses EA on EA.id = ABR.email_address_id



Regards,