Syntax: INET_NTOA(expr) Given a numeric IPv4 network address in network byte order, returns the dotted-quad representation of the address as a string. INET_NTOA() returns NULL if it does not understand its argument. As of MySQL 5.5.3, the return value is a nonbinary string in the connection character set. Before 5.5.3, the return value is a binary string. URL: https://mariadb.com/kb/en/inet_ntoa/
MariaDB> SELECT INET_NTOA(167773449); -> '10.0.5.9'