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


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

. has a special meaning in regexps. Therefore, ^10.100.1.1 in fact means From the beginning, 1, 0, anything, 1, 0, 0, anything, 1, anything, 1.
10.100.101 matches your regexp: the last 0 corresponds to the last dot.
لսႽ† ᥲᥒ⚪⟊Ⴙᘓᖇ Ꮅᘓᖇ⎱ Ⴙᥲ𝇋ƙᘓᖇ