top of page
CerebroSQL

MySQL: 

INET_NTOA

Syntax:
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.

URL: https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html

Example

mysql> SELECT INET_NTOA(167773449);
-> '10.0.5.9'

bottom of page