Hi,

js wrote:
Hi Baron.
Thanks for reply.

If I understand correctly,
inet_ntoa() and inet_aton() are not capable of handling CIDR notation.

Very true, I didn't quite understand the syntax you were using. But you can still use bitwise arithmetic to work around this. Scott Noyes wrote a nice post with examples: http://thenoyes.com/littlenoise/?p=49

On 5/15/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hello,

js wrote:
> Hi.
>
> Today I found postgresql's neat feature, inet operators,
> which allows you to do
>
> inet '192.168.1/24' >> inet '192.168.1.5'
>
> http://www.postgresql.org/docs/current/static/functions-net.html
>
> Is there anyway to do this using MySQL?

Yes.  Have a look at the inet_ntoa() and inet_aton() functions.

Cheers
Baron


--
Baron Schwartz
http://www.xaprb.com/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to