By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 10.5.17-MariaDB-1:10.5.17+maria~deb11 |
create table a_table ( normal_value text, secret_value blob)
insert into a_table values ('normal', 0x30e9bfa342cd1ff84cd50724f7b4617b)
select normal_value, aes_decrypt(secret_value, 'secret_key') from a_table
| normal_value | aes_decrypt(secret_value, 'secret_key') |
|---|---|
| normal | 0.123 |