Jonathan Gorman wrote:
> I think what's Ken is asking for though is there some combination of the
> IN operator and LIKE operator.  He's trying to exclude a set of patterns,
> ie converting (ip NOT LIKE "127.%" OR ip NOT LIKE "143.123.%").
yup - that's exactly what i'm trying to do.
> say much), but if by some stroke of luck you filter based on a certain
> part of the address you could do a substring function.
>
> SELECT *  FROM iptables
> WHERE substring(iptables,1,7) NOT IN (127.475,...)
sadly, my data isn't quite regular enough for that. it could simply be
that MySQL isn't built to handle this kind of query.

thanks
Ken

--
Ken Irwin
Reference Librarian
Thomas Library, Wittenberg University