Re: (OT) mysql regexp unwanted matches for specific IP

[McDarren]

If you're looking for a specific IP address, then why bother messsing around with a pattern match?

I mean, what's wrong with:

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

P.S. This is a Perl site, not a MySQL site ;-)