mysql> select d07 from service where d07 regexp '^10.100.1.1';
+------------------------------------------------+
| d07                                            |
+------------------------------------------------+
| 10.100.101.186 on at 2011-06-20 02:12:02       |
| 10.100.101.188 at 2009-05-12 05:12:47          |
| 10.100.101.251 at 2009-03-26 16:00:37          |
| 10.100.101.182 at 10282300                     |
| 10.100.101.70 on at 2011-04-25 02:16:27        |
| 10.100.101.59 off since 2012-02-18 18:52:04    |

. . .