On 10/10/2010 14:04, Jeremy Harris wrote:
>> If you just stored network addresses like 41.0.0.0/8, you'd have to
>> fetch the entire table, hence my long description of using IP numbers.
>
> Nothing stopping you doing a CIDR match as part of the lookup, surely?
>
> Perhaps MySQL doesn't support them; my apologies.
> I'm a Postgresql person by preference.
It doesn't support anything like that no.
--
Mike Cardwell - Perl/Java/Web developer, Linux admin, Email admin
Read my tech Blog - https://secure.grepular.com/
Follow me on Twitter - http://twitter.com/mickeyc
Hire me - http://cardwellit.com/ http://uk.linkedin.com/in/mikecardwell