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?
Other opinion (please explain)
Results (257 votes),