http://www.perlmonks.org?node_id=1016067


in reply to Re: (OT) mysql regexp unwanted matches for specific IP
in thread (OT) mysql regexp unwanted matches for specific IP

Almost there, but to match the OP's criteria you'll need an extra whitespace, so assuming the address is the first string in the field:

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

It still has nothing to do with Perl, though.