## Adding and testing AES encrypted password field

DROP TABLE IF EXISTS `testGKAES`;


create table `testGKAES`(
`uid` int(15) not null AUTO_INCREMENT,
`ufname` varchar(15),
`upassword` BLOB,
primary key(`uid`)
);

INSERT INTO testGKAES VALUES('1','user', AES_ENCRYPT('password', 'key') );
INSERT INTO testGKAES VALUES('2','mere', AES_ENCRYPT('balloon', 'key') );
INSERT INTO testGKAES VALUES('3','kurtasg', AES_ENCRYPT('zebra', 'key') );

SELECT * FROM testGKAES WHERE ufname='user' AND upassword=AES_ENCRYPT('password','key');
SELECT * FROM testGKAES WHERE ufname='mere' AND upassword=AES_ENCRYPT('balloon','key');
SELECT * FROM testGKAES WHERE ufname='kurtasg' AND upassword=AES_ENCRYPT('zebra','key');

SELECT AES_DECRYPT(upassword,'key') FROM testGKAES;

Adding and testing AES encrypted password field

MySQL