mysql> select name, type,ordername, auth from records where name like '%a.aa' limit 73; +-----------------------------------+-------+---------------------+------+ | name | type | ordername | auth | +-----------------------------------+-------+---------------------+------+ | a.aa | SOA | | 1 | | a.aa | NS | | 1 | | a.aa | A | | 1 | | ns1.a.aa | A | ns1 | 1 | | ns2.a.aa | A | ns2 | 1 | | tnt-gw.a.aa | A | tnt-gw | 1 | | tnt1.a.aa | A | tnt1 | 1 | | tnt2.a.aa | A | tnt2 | 1 | | tnt-gw2.a.aa | A | tnt-gw2 | 1 | | tnt-gw1.a.aa | A | tnt-gw1 | 1 | | sesm-gw.a.aa | A | sesm-gw | 1 | | sesm1.a.aa | CNAME | sesm1 | 1 | | sesm2.a.aa | CNAME | sesm2 | 1 | | sesm.a.aa | A | sesm | 1 | | ssg1.a.aa | A | ssg1 | 1 | | ssg2.a.aa | A | ssg2 | 1 | | ssg1-co1-gw.a.aa | A | ssg1-co1-gw | 1 | | ssg2-co2-gw.a.aa | A | ssg2-co2-gw | 1 | | co1-ssg1-gw.a.aa | A | co1-ssg1-gw | 1 | | co2-ssg2-gw.a.aa | A | co2-ssg2-gw | 1 | | ssg-internet-gw.a.aa | A | ssg-internet-gw | 1 | | nagios1.a.aa | A | nagios1 | 1 | | relay1.a.aa | A | relay1 | 1 | | relay2.a.aa | A | relay2 | 1 | | ems1.a.aa | A | ems1 | 1 | | pwas2.a.aa | CNAME | pwas2 | 1 | | pwas.a.aa | A | pwas | 1 | | pwasdocs.a.aa | A | pwasdocs | 1 | | gcdb.a.aa | A | gcdb | 1 | | gcdb1.a.aa | A | gcdb1 | 1 | | gcdb2.a.aa | A | gcdb2 | 1 | | gc1.a.aa | A | gc1 | 1 | | gc2.a.aa | A | gc2 | 1 | | gc3.a.aa | A | gc3 | 1 | | gc4.a.aa | A | gc4 | 1 | | voip1.a.aa | A | voip1 | 1 | | inbound.smtp.a.aa | A | smtp inbound | 1 | | inbound.smtp.a.aa | A | smtp inbound | 1 | | outbound.smtp.a.aa | A | smtp outbound | 1 | | outbound.smtp.a.aa | A | smtp outbound | 1 | | relay.smtp.a.aa | CNAME | smtp relay | 1 | | ftp.a.aa | A | ftp | 1 | | mail.a.aa | A | mail | 1 | | smtp.a.aa | A | smtp | 1 | | pop.a.aa | A | pop | 1 | | pop3.a.aa | A | pop3 | 1 | | imap.a.aa | A | imap | 1 | | nagios.a.aa | CNAME | nagios | 1 | | news.a.aa | CNAME | news | 1 | | ntp.a.aa | A | ntp | 1 | | scripts.a.aa | CNAME | scripts | 1 | | speedtest.a.aa | CNAME | speedtest | 1 | | tickets.a.aa | A | tickets | 1 | | user.a.aa | CNAME | user | 1 | | *.user.a.aa | CNAME | user * | 1 | | webcast.a.aa | CNAME | webcast | 1 | | webmail.a.aa | A | webmail | 1 | | www.a.aa | A | www | 1 | | eupdates.a.aa | A | eupdates | 1 | | eupdates.a.aa | MX | eupdates | 1 | | gru-fal-gw.customer.a.aa | A | customer gru-fal-gw | 1 |< I changed this one myself, used to be NULL | fal-gru-gw.customer.a.aa | A | NULL | NULL | | gru-therock-gw.customer.a.aa | A | NULL | NULL | | therock-gru-gw.customer.a.aa | A | NULL | NULL | | gru-cardio-gw.customer.a.aa | A | NULL | NULL | | cardio-gru-gw.customer.a.aa | A | NULL | NULL | | gru-asterisk-gw.customer.a.aa | A | NULL | NULL | | asterisk-gru-gw.customer.a.aa | A | NULL | NULL | | gru-barrsys-gw.customer.a.aa | A | NULL | NULL | | barrsys-gru-gw.customer.a.aa | A | NULL | NULL | | gru-blueskies-gw.customer.a.aa | A | NULL | NULL | | blueskies-gru-gw.customer.a.aa | A | NULL | NULL | | gru-alligator-gw.customer.a.aa | A | NULL | NULL | +-----------------------------------+-------+---------------------+------+ 73 rows in set (0.01 sec)