) for IPv6 and
IPv4 addresses respectively.

Returns NULL if the argument is not understood.

MariaDB starting with 10.5.0
----------------------------
From MariaDB 10.5.0, INET6_ATON can take INET6 as an argument.

Examples
--------

SELECT HEX(INET6_ATON('10.0.1.1'));
+-----------------------------+
| HEX(INET6_ATON('10.0.1.1')) |
+-----------------------------+
| 0A000101                    |
+-----------------------------+

SELECT HEX(INET6_ATON('48f3::d432:1431:ba23:846f'));
+----------------------------------------------+
| HEX(INET6_ATON('48f3::d432:1431:ba23:846f')) |
+----------------------------------------------+
| 48F3000000000000D4321431BA23846F             |
+----------------------------------------------+

URL: https://mariadb.com/kb/en/inet6_aton/https://mariadb.com/kb/en/inet6_aton/