View Single Post
Old 2nd November 2012, 17:27
Croydon Croydon is offline
ISPConfig Developer
Join Date: Jul 2007
Location: Koblenz, Germany
Posts: 932
Thanks: 16
Thanked 264 Times in 208 Posts

In general there is no direct link (in the database) between ONE web domain and email addresses!

If you want to access a list of emails that MIGHT(!) be connected to a given WEB domain you could try doing a join like this.

SELECT email FROM mail_user INNER JOIN web_domain ON (SUBSTR(email, INSTR(email, '@')+1) = domain) WHERE web_domain.domain_id = 12345

It's not guaranteed to work because of the things I stated above.
Marius Cramer

pixcept KG
Reply With Quote