encryption - who to work AES_DECRYPT in mysql? -

i use aes_encrypt(...) in mysql encrypte column of table when use aes_decrypt decrypte, result null.

please me. thanks.

code encrypt:

update tbl_users set password = aes_encrypt(password , '123456'); 

code decrypte:

select cast(aes_decrypt(password,'123456') char) tbl_users 

password must string 'password'. password without quotes field name.

update tbl_users set password = aes_encrypt('password' , '123456'); 

try aes_decrypt witout cast function:

select aes_decrypt(password,'123456') tbl_users