Mark Martinec wrote:
Why domain in maddr table is in 'subdomain fields in reverse' format?
To facilitate producing a quick by-domain summary report by a single SELECT.
Mark,
I think this kind of query is not in the documentation, right?
Do you have any ready-to-use examples for this kind
Paolo Cravero as2594 napisał(a):
Mark,
I think this kind of query is not in the documentation, right?
Do you have any ready-to-use examples for this kind of reports?
Perhaps they were posted on this list so they're in the archives?!
Hint: SUBSTRING_INDEX(domain, '.', 1)
--
Paolo,
Why domain in maddr table is in 'subdomain fields in reverse' format?
To facilitate producing a quick by-domain summary report by a single
SELECT.
I think this kind of query is not in the documentation, right?
The schema is documented, the rest is up to your needs, imagination
and
guzik,
Why domain in maddr table is in 'subdomain fields in reverse' format?
To facilitate producing a quick by-domain summary report by a single SELECT.
It is not used for anyhing else. The address in normal order is available in
other fields.
Mark
HELO,
Why domain in maddr table is in 'subdomain fields in reverse' format?
guzik
---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live