MariaDB 10.5

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

10.5.29-MariaDB-deb11

-- the INET6 type arrived in MariaDB 10.5
create table host (name varchar(10), addr inet6);
insert into host values ('a','2001:db8::1'),('b','::1');

Records: 2  Duplicates: 0  Warnings: 0

select name, addr from host order by name;

name
addr

a
2001:db8::1

b
::1