docs/sql-manual/sql-functions/ip-functions/to-ipv4.md

{ “title”: “TO_IPV4”, “language”: “en” }

TO_IPV4

Description

Syntax

IPV4 TO_IPV4(STRING ipv4_str)

This function like ipv4_string_to_num that takes a string form of IPv4 address and returns value of IPv4 type, which is binary equal to value returned by ipv4_string_to_num. If the IPv4 address has an invalid format, throw an exception.

Notice

Input cannot be NULL. If it is NULL, an exception will be thrown.

Example

mysql> select to_ipv4('255.255.255.255');
+----------------------------+
| to_ipv4('255.255.255.255') |
+----------------------------+
| 255.255.255.255            |
+----------------------------+

Keywords

TO_IPV4, IP