how to convert ip address to dot notation

[Eddie Corns]

Ruslan Spivak <alienoid at is.lg.ua> writes:

>Hello, python users!

>I have ip addresses in my mysql db in int value - 3232261127, for example.
>How can i convert that to usual dot notation like 192.168.100.7?

mysql itself can do this, use inet_ntoa() eg

select inet_ntoa (...) from ...

or alternatively use inet_aton() inside the query eg:

select ... from ... where x = inet_aton ('192.168.100.7')

Eddie