Select Code to Download

Select or download this

select * from table where field regexp '^10.100.1.1'
select * from table where field regexp '10\.100\.1\.1'
select * from table where field regexp '10\.100\.1\.1[[:>:]]'
select * from table where field regexp '[[:<:]]10\.100\.1\.1[[:>:]]'

Select or download this

mysql> select d07 from service where d07 regexp '^10.100.1.1';
+------------------------------------------------+
...
| 10.100.101.59 off since 2012-02-18 18:52:04    |

. . .