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