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

task: seek record that contains a specific IP
Why not just select * from table where field = '10.100.1.1'? If you want one specific, known IP why use regexp or like?

In Section Seekers of Perl Wisdom