Select Code to Download

mysql> select state,d09,d07 from service where d07 like '%10.100.1.1%'
+;
+-------+--------------------------+--------------+
...
|     0 | br1.glbx 28281           | 10.100.1.1   |
+-------+--------------------------+--------------+
8 rows in set (0.02 sec)

mysql> select state,d09,d07 from service where d07 like '%10.100.1.1';
...
|     0 | br1.glbx 28281 | 10.100.1.1 |
+-------+----------------+------------+
1 row in set (0.02 sec)