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
