select * from table where field like '%10.100.1.1%';