INET_NTOA(expr)

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

MYSQL Copy

SELECT INET_NTOA(167773449);
'10.0.5.9'

Examples

Example

MYSQL Copy

SELECT INET_NTOA(167773449);
'10.0.5.9'