4 ms·
> I guess if you ever need to match on a specific prefix storing the numeric IP might be an issue? If you want to search for range, you can do: SELECT INET
by Ginden 5y ago
> I guess if you ever need to match on a specific prefix storing the numeric IP might be an issue?
If you want to search for range, you can do:
SELECT INET_NTOA(ip) FROM ips WHERE ip > INET_NTOA(:startOfRange) AND ip < INET_NTOA(:endOfRange)