INET_NTOA

Given a numeric IPv4 network address in network byte order, returns the dotted-quad string representation of the address as a string in the connection character set. INET_NTOA() returns NULL if it does not understand its argument.

Syntax

INET_NTOA(expr)

Example

SELECT INET_NTOA(201328137);

The above query returns 12.0.6.9