TO_IPV4_OR_NULL
Descriptionβ
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.
Syntaxβ
TO_IPV4_OR_NULL(<ipv4_str>)
Parametersβ
| Parameter | Description |
|---|---|
<ipv4_str> | An IPv4 address of type String |
Return Valueβ
Returns value of IPv4 type.
- If the IPv4 address has an invalid format, returns NULL.
Exampleβ
SELECT to_ipv4_or_null('255.255.255.255'), to_ipv4_or_null('.'), to_ipv4_or_null(NULL);
+------------------------------------+----------------------+-----------------------+
| to_ipv4_or_null('255.255.255.255') | to_ipv4_or_null('.') | to_ipv4_or_null(NULL) |
+------------------------------------+----------------------+-----------------------+
| 255.255.255.255 | NULL | NULL |
+------------------------------------+----------------------+-----------------------+
