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