A. create function LIBCRYPT.AES_ENCRYPT(string,string) returns string;

  create function LIBCRYPT.AES_DECRYPT(string,string) returns string;

B. insert into tableXX(columnXX) values(AES_ENCRYPT(‘XXXXXX’, 'user_defined_key'));

 Or update tableXX set columnXX=AES_ENCRYPT(columnXX, 'user_defined_key');

C.  select AES_DECRYPT(column1, ‘user_defined_key’) from table1;