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[[:>:]]'